How to query System generated columns on Developer Edition

Zhang, Li 0

We are using EF 8.0 to manage data, one of the recent challenges is that the query on SQL Server Developer Edition and Enterpise Edition returns different results.

i.e., two columns StartTime/EndTime are generated like

entity.Property(e => e.StartTime).ValueGeneratedOnAddOrUpdate();

However, a rawSql (Select *) won't return those two columns on Developer Edition. My question: how to write the right query disregarding the different editions? Thanks.

Erland Sommarskog 114.4K Reputation points MVP

2024-12-23T22:50:09.34+00:00

I have no idea what that code does - I'm not a friend of Entity Framework. But that much I can say: The edition of SQL Server does not matter. Rather there are other differences between the databases in the different machines. Or in the object-relational model (or whatever you have in EF.)

You could use Profiler to see what EF actually submits to SQL Server on the two instances. Presumably there are differences. Also trace that "rawSql query".
LiHongMSFT-4306 29,441 Reputation points

2024-12-24T01:45:03.9266667+00:00

However, a rawSql (Select *) won't return those two columns on Developer Edition.

How about specify these two columns like SELECT Id, StartTime, EndTime FROM YourEntityTable?

Share via

How to query System generated columns on Developer Edition

Your answer