Entity framework

[columbos14927]

Hello, I am a new in EF. I have a Customewr class:

public class Customer
{
public int CustomerId { get; set; }
public string Name { get; set; }
public string Email { get; set; }
}

And here is my DbContext class:

public class DiveShopContext:DbContext
{
public DbSet<Customer> Customers { get; set; }
}

I want to be able to save Customers to my DB, i do it as follow:
<pre lang="cs">class Program
{
static void Main(string[] args)
{
using (var db = new DiveShopContext())
{

       var customer = new Customer();
       customer.CustomerId = 3045;
       customer.Name = "Alex";

       db.Customers.Add(customer);
       db.SaveChanges();
   }
}

}</pre>

Every thing is saved fine but the CustomerId is changed from 3045 to 1 and saved.

[jschell]

Presumably what you actually mean is that when you save it and then look at the saved customer that the customer id is then 1 instead as you expected being 2945. Presuming that you are in fact looking at the correct database/table/column then I would suppose that the specific column is an auto index column. And you shouldn't be attempting to set the id in the first place.

[S Douglas]

columbos14927 wrote:

but the CustomerId is changed from 3045 to 1 and save

I am going to guess that CustomerID at the database level is an Identity Column? If that's the case then the value you are trying to set is not going to be accepted by the database engine.

---

Common sense is admitting there is cause and effect and that you can exert some control over what you understand.