Add Object with Primary Key

Question

My english isn't perfect but I'll try:

I'm making an application to import data from another knowed database. And my actual problem is to save that primary key I've set, something like this:

 foreach (TB_FILIAIS filial in dadosMulti.TB_FILIAIS.ToList())
        {
            EMPRESA objEmpresa = new EMPRESA();
            objEmpresa.ID = filial.CODLOJA;
            dadosVistaERP.AddObject(typeof(EMPRESA).Name, objEmpresa);
        }
     dadosVistaERP.SaveChanges();

I really need to save that objEmpresa.ID I've set.

DadosMulti and dadosVistaERP are my ObjectContext that I'm using to do the import.

The table EMPRESA is Identity(1,1) on column ID

Can anyone help me?

the ID property is always saving with auto-increment and not what I had set — Leandro Guyss, Aug 27 '13 at 21:07
possible duplicate from [Disabling identity (auto-incrementing) on integer primary key](http://stackoverflow.com/questions/7206273/disabling-identity-auto-incrementing-on-integer-primary-key-using-code-first) ? — Reza Shirazian, Aug 27 '13 at 21:09
i've tried to do this "SET IDENTITY_INSERT YourTableName ON", but the EF keep inserting with auto-increment. And here I work with Model First — Leandro Guyss, Aug 27 '13 at 21:13
possible duplicate of [Turn on IDENTITY\_INSERT in Entity Framework, SQL Server 2008?](http://stackoverflow.com/questions/7063787/turn-on-identity-insert-in-entity-framework-sql-server-2008) — Kirk Broadhurst, Aug 27 '13 at 21:17
Also http://stackoverflow.com/questions/3332003/using-identity-insert-with-ef4 - if you search for identity insert entity framework you'll find examples. — Kirk Broadhurst, Aug 27 '13 at 21:18
This is a good question but I've voted to close due to duplicates. — Kirk Broadhurst, Aug 27 '13 at 21:18
The problem to do that Kirk Broadhurst said, is, I've about 70 entities. There is no way to do this by code? — Leandro Guyss, Aug 27 '13 at 21:35

Add Object with Primary Key

0 Answers0