The column name is not valid. [ Node name (if any) = t0,Column name = version ]

Question

I am facing issue while trying to query SQLCE database in my Windows Phone Mango application.

I get exception when I execute

foreach (var item in myDataContext.MyTable.Select(item => item))

The column name is not valid. [ Node name (if any) = t0,Column name = version ]

Strangely, when I execute query based on any individual column, it works fine

foreach (var item in myDataContext.MyTable.Select(item => item.SomeColumn))

Any idea what could be wrong here?

Is your version column the `primary key`? – Tigran Jan 29 '12 at 18:33 — Tigran, Jan 29 '12 at 18:33
I don't have a version column – Haris Hasan Jan 29 '12 at 18:35 — Haris Hasan, Jan 29 '12 at 18:35

score 5 · Accepted Answer · answered Jan 29 '12 at 19:08

I installed LINQ to SQL Debug Visualizer to find out what query exactly is being generated behind the scene and it was

{SELECT [t0].[version], [t0].[ID], [t0].[Volume], ... similarly rest of the columns FROM [MyTable] AS [t0]

This was strange because I didn't had version column in my table (ever). I looked into my model and I found this column defined

[Column(IsVersion = true)]
private Binary version;

I removed column by commenting out these two lines and re-ran the app. Newly generated SQL didn't had any version column and my query worked fine.

I am using SQLCEMangoCodeGenerator for generating LINQ to SQL classes. I guess error is in this tool because of which it generated an extra column which I didn't have in my table

Try using the SQL Server Compact Toolbox to generate the DataContext! — ErikEJ, Jan 30 '12 at 08:18

score 2 · Answer 2 · answered Apr 26 '12 at 23:34

I was having the same issue with the "SQLCEMangoCodeGenerator" tool.

I started to use the "SQL Server Compact Toolbox" tool and I haven't had any issues: http://visualstudiogallery.msdn.microsoft.com/0e313dfd-be80-4afb-b5e9-6e74d369f7a1/

(search for "NEW: DataContext" on the above website for a screen shot. Once you've installed the Extension, click the "SQL Server Compact Toolbox" in the Tools menu)

score 1 · Answer 3 · answered Aug 19 '14 at 09:56

1

I solved this issue by removing the whole database and recreate it.

Obivously, this happens, if you have older version of table in database than you want to use, thus that column does not exist in that table.

answered Aug 19 '14 at 09:56

libik

22,239
9
44
87

score 0 · Answer 4 · answered Dec 25 '14 at 01:58

0

In SqlCE.sdf with SQL Server Managment Studio run:

DELETE FROM [User] WHERE [User].[UserName] = "zz"

got similar issue with column name not valid, but changed quotations to apostrophes:

DELETE FROM [User] WHERE [User].[UserName] = 'zz'

and it worked!

answered Dec 25 '14 at 01:58

Vladimir Vukanac

944
16
29

The column name is not valid. [ Node name (if any) = t0,Column name = version ]

4 Answers4

Linked