Omitting columns from Stored Procedures, DAL, BLL and PL

I have been trying to do this with no luck. I get an 'Exception has been thrown by the target of the invocation.' error after the End Get here.

PrivateReadOnlyProperty Adapter()As System.Data.SqlClient.SqlDataAdapter

Get

If (Me._adapterIsNothing)Then

Me.InitAdapter

EndIf

ReturnMe._adapter

EndGet

EndProperty

The app setup is an SQL Server / Stored Procedured / UDFs // DAL / BLL / PL. I omitted two columns from the table. The columns are currently being used by another app but are being phased out with this new app so they will eventually be deleted. Is this the proper way to do this or do I have to include them in the SP / DAL / BLL until the columns are actually deleted?

Your new application should be able to completely ignore the 2 columns you are depreciating, provided that the two columns are marked as allowing null values.

If the two column "are" marked as allowing null values and it is generating this error, I suppose you could check for triggers or dependencies on the columns. Otherwise your error is probably coming from somewhere else other than the missing 2 columns.