How to get ID from data base?

Question

i have a table name AddFIR  i want that when i click the button to save the record FIRid Will be show on that time. e.g; Your FIR Was Successfully Saved And Your FIR ID IS : 55   anyone help me how i resolve this method?

Prateek Singla · Answer

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 Mohapatra · Answer

Try like below: using (var context = new MyContext()) { FirInfo firObject = new firObject(); firObject.name = YourName ; firObject.desc = testing ; context.MyEntities.AddObject(firObject); context.SaveChanges(); int id = firObject.Id; // Yes it's here } Entity framework by default follows each INSERT with SELECT SCOPE_IDENTITY() when auto-generated Ids are used.

Bilawal Niaz · Answer

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 Mohapatra · Answer

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: public int SaveFIR( string name string desc) { int firID; SqlConnection con = new SqlConnection(Config.ConnectionString); using (SqlCommand cmd= new SqlCommand(INSERT INTO tblFIR(Name Desc) VALUES(@name @desc); SELECT SCOPE_IDENTITY();con)) { cmd.Parameters.AddWithValue( @name  test ); cmd.Parameters.AddWithValue( @desc  description ); con.Open(); firID = cmd.ExecuteScalar(); if (con.State == System.Data.ConnectionState.Open) con.Close(); return firID; } } int firID = SaveFIR( test  description ); if (firID == 0) { Console.WriteLine( Some error occurred...  ); } else { Console.WriteLine( Fir saved successfully and your FIR ID:  + SaveFIR( test  description )); }