How to get ID from data base?

Bilawal Niaz

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?

4 Replies

Know the answer? Post it — somebody with the same question will find it here.

Prateek Singla9y ago
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 ago
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 Niaz9y ago
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 ago
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"));
}