How to get ID from data base?

Sign in to answer this question.

• 

  Prateek Singla9y agoPosted Nov 21, 2016, 1:47 AM

  Entity Framework will automatically load the last inserted id to populate the primary key column of the inserted entity:

  var customer = new Customer() { Name = "Steven" };  context.AddObject(customer);  context.SaveChanges();  var id = customer.Id;

  Note that the Id property only gets populated after calling SaveChanges() in case the StoreGeneratedPattern attribute is set to "Identity" or "Computed" for the auto-incremented ID column in the Storage part of the model.
• 

  Manas Mohapatra9y agoPosted Nov 21, 2016, 1:46 AM

  Try like below: 

  1. using (var context = new MyContext())  
  2. {  
  3.     FirInfo firObject = new firObject();  
  4.   
  5.     firObject.name = "YourName";  
  6.     firObject.desc = "testing";  
  7.   
  8.     context.MyEntities.AddObject(firObject);  
  9.     context.SaveChanges();  
  10.   
  11.     int id = firObject.Id; // Yes it's here  
  12. }  
  13.   
  14. Entity framework by default follows each INSERT with SELECT SCOPE_IDENTITY() when auto-generated Ids are used.  

   
• BN

  Bilawal Niaz9y agoPosted Nov 20, 2016, 9:19 PM

  brother i used entity frame work, and this is dot.net code...........!   can you give me sample code using entity frame work in asp.net
• 

  Manas Mohapatra9y agoPosted Nov 20, 2016, 1:18 PM

  Create a function which will connect to database to save your FIR. Secondly you need to execute multilple SQL statement at a time. Try with below code:

  1. public int SaveFIR(string name, string desc)  
  2. {  
  3.     int firID;  
  4.     SqlConnection con = new SqlConnection(Config.ConnectionString);  
  5.       
  6.     using(SqlCommand cmd=new SqlCommand("INSERT INTO tblFIR(Name, Desc) VALUES(@name, @desc);   
  7.     SELECT SCOPE_IDENTITY();",con))  
  8.     {  
  9.         cmd.Parameters.AddWithValue("@name", "test");  
  10.         cmd.Parameters.AddWithValue("@desc", "description");  
  11.         con.Open();  
  12.   
  13.         firID = cmd.ExecuteScalar();  
  14.   
  15.         if (con.State == System.Data.ConnectionState.Open) con.Close();  
  16.             return firID;  
  17.     }  
  18. }  
  19.   
  20. int firID = SaveFIR("test", "description");  
  21. if(firID == 0)  
  22. {  
  23.     Console.WriteLine("Some error occurred... ");  
  24. }  
  25. else  
  26. {  
  27.     Console.WriteLine("Fir saved successfully and your FIR ID: " + SaveFIR("test", "description"));  
  28. }