Skip to content Skip to sidebar Skip to footer

How To Get The Next Sequence Number In Sql Server Express Using Entity Framework?

Now that Sql Server 2012 (including SQL Server Express 2012) has SEQUENCE feature just like Oracle as explained here, here, and here. I can get the next sequence like so, SELECT NE

Solution 1:

I got it working using SqlQuery like so..

int sequence = context.Database.SqlQuery<int>("SELECT NEXT VALUE FOR MySequenceName").FirstOrDefault();

Post a Comment for "How To Get The Next Sequence Number In Sql Server Express Using Entity Framework?"