Monday, October 31, 2016

sql auto increment jump

You resolve your auto increment  jumping from this

you can also resolve the issue into another way if you are using EDMX.

Before inserting data into table get the max id value from your table.

 int maxAge = context.Persons.Max(p => p.Age);  

Now add your increment number maxAge+1  

Map the id value with your table.

NB: You table Identity specification : Is Identity Will be no.

Ensure that this project has Microsoft.Bcl.Build installed and packages.config is located next to the project file

In my Xamarin form application their was dependency Restclient on Microsoft.Bcl.Build Microsoft.Bcl. i just remove all using nuget and ...