Veritabanına eklen son kaydın id'sini alma

Ms access için : Select @@Identity 

//C#

string query = "Insert Into Categories (CategoryName) Values (?)";

string query2 = "Select @@Identity";

int ID;

string connect = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=|DataDirectory|Northwind.mdb";

using (OleDbConnection conn = new OleDbConnection(connect))

{

  using (OleDbCommand cmd = new OleDbCommand(query, conn))

  {

    cmd.Parameters.AddWithValue("", Category.Text);

    conn.Open();

    cmd.ExecuteNonQuery();

    cmd.CommandText = query2;

    ID = (int)cmd.ExecuteScalar();

  }

}

Ms sql için :       Select Scope_Identity()

//C#

string query = "Insert Into Categories (CategoryName) Values (@CategoryName);" +

"Select Scope_Identity()";

int ID;

string connect = @"Server=.\SQLExpress;AttachDbFilename=|DataDirectory|Northwind.mdf;" +

    "Database=Northwind;Trusted_Connection=Yes;";

using (SqlConnection conn = new SqlConnection(connect))

{

  using (SqlCommand cmd = new SqlCommand(query, conn))

  {

    cmd.Parameters.AddWithValue("@CategoryName", Category.Text);

    conn.Open();

    ID = (int)cmd.ExecuteScalar();

  }

}

Kaynak : http://www.mikesdotnetting.com