Adding Column to Table Causes DALC Error

4 views
Skip to first unread message

CantelopeHead

unread,
Apr 13, 2010, 2:55:55 PM4/13/10
to nicnet
Newby to Nicnet - Inherited a project that uses it. I added a column
to a table (big int of identity type) in SQL Server which is auto
populate on inserts and not required on updates, however I'm now
seeing errors when updating data in this table. "Unable to add column
(new column name) to the data" or "Error in DALC" I think are the
errors. How do we fix this? Thanks in advance - I'm stuck.

Vitalik

unread,
Apr 13, 2010, 4:06:27 PM4/13/10
to nicnet
DALC is built over standard ADO.NET infrastructure; it just provides
high level interface for data access layer.
So you should analyze exception stacktrace and try to find the root of
problem; in some applications (it depends on concrete application
architecture, not DALC) you cannot just add a new column without
updating application data schema. Maybe this is your case.

Pavlo Zahozhenko

unread,
Apr 13, 2010, 4:28:27 PM4/13/10
to nicnet
Are you sure that adding a column directly to the database is the
right way to do it in your application? Some applications use
configuration files to store DB schema info, you change the
configuration file and DB schema gets auto-regenerated. If your
application follows this pattern, you just need to find and modify the
appropriate configuration file to fix the problem.
Another easy solution I can think of is restarting your application/
SQL server/computer. As silly as it sounds, it might work: sometimes
the error is caused by cached old schema, restart invalidates the
cache and the problem disappears.
Reply all
Reply to author
Forward
0 new messages