How to get IDENTITY number of insert query C#

I have added my sample code snippet below to retrive Identity number when run the insert query. You have to create connection string and other parameter names as you wanted.

using (var con = new SqlConnection(ConnectionString)) {

    int newID;

    var cmd = "INSERT INTO foo (column_name)VALUES (@Value);SELECT CAST(scope_identity() AS int)";

    using (var insertCommand = new SqlCommand(cmd, con)) {

        insertCommand.Parameters.AddWithValue("@Value", "bar");

        con.Open();

        newID = (int)insertCommand.ExecuteScalar();

    }

}