LINQ Data Source: displays extra columns for my table:
ClientTarget, IsCallback, MaxPageStateFieldLength,
IsPostBack, etc...

This is odd, I created a LINQ data source and pointed it to my data context and
when I pick one of my 4 tables it displays extra "bogus" columns.

In my .dbml database model I have a Staff table, it has basic columns like
FName, LName, etc... those all appear properly and there are NO extra columns
there.

 

If I go to VS2008's designer for an ASP.NET page and drag and drop a
LinqDataSource onto the page, point it to my data context object then select the
Staff table I see in my column list a LOT of extra columns like:

ClientTarget
ClientQueryString
ErrorPage
IsCallback
IsReusable
IdSeparator
MaintainScrollPositionOnPostBack
MasterPageFile
MaxPageStateFieldLength
Title
Theme
StyleSheetTheme
IsCrossPagePostBack
....

the list goes on.

 

What is going on here???!!!

 

Any idea what is happening and how to fix this?

bump....?

Hi Maxer_Ars,

Your issue is so strange, I never encounter this before. But I guess there's two
points may have errors.

First, please check the data entity and see whether all the columns are mapped
with tables in database. Ensure the mapping is correct and no extra columns. You
can use "Go to definition" to see the codes or open the generated
codes file directly. 

Second, please ensure your LINQ query is correct. When we want to select the
table, we can use:

var sel = from u in ctx.Users

             select u;

 

If you still can't find the error, please drop and re-drag the table, and try
again. 

 

Hope this helps you!