Options
Linqpad can't add row to table with rowguid default value
I have a table with replication enabled. This table added a rowguid column for replication purposes with a default value of (newsequentialid()).
When I use grid mode in linqpad to try to add a new row to this table, it doesn't use the default value and instead inserts a guid of 0000... when I'd prefer to submit the row with no value for rowguid, and allow it to be populated by executing the default value.
Is there a way to use the default value?
-Karl
When I use grid mode in linqpad to try to add a new row to this table, it doesn't use the default value and instead inserts a guid of 0000... when I'd prefer to submit the row with no value for rowguid, and allow it to be populated by executing the default value.
Is there a way to use the default value?
-Karl
Comments
Entity Framework 6 has the same problem, FWIW. However, this has been fixed in EF Core. When EF Core matures, I'll add an automatic context-buildling driver to LINQPad for EF Core, so you'll be able to choose between LINQ to SQL or EF Core when automatically building a context. (Right now, it wouldn't be so useful, because EF Core still lacks some essential features.)