ADO_Insert

ADO_Insert.cs

using (var connection = new SqlConnection(connectionString))
{
    connection.Open();
    using (var command = connection.CreateCommand())
    {
        command.CommandText = "INSERT INTO [dbo].[Customer](Name, ..., CreatedDateUtc) VALUES (@Name, ..., @CreatedDateUtc); SELECT SCOPE_IDENTITY();";
        command.Parameters.AddWithValue("@Name", customer.Name);
        ...
        command.Parameters.AddWithValue("@CreatedDateUtc", customer.CreatedDateUtc);
        return (int)command.ExecuteScalar();
    }
}