How to make LINQPad work with SQL Server's graph?

181 views Asked by At

Graph Table in SQL Server automatically added an internal graph_ID_ column for user. When querying the table in LINQPad, got this error.

enter image description here

Here is the SQL being generated in LINQPad. Looks like LINQ_TO_SQL detected this column, and treated this column as normal column, but SQL Server does not allow us to access it.

enter image description here

I can write LINQ query without this column, it works OK. but since it's a custom query, I lost the ability to edit the record.

enter image description here

0

There are 0 answers