public static void Main() { using (var sqlConnection = new SqlConnection(Constant.DatabaseConnection)) { sqlConnection.Open(); var supplier = new Supplier() { Address = "10 Main Street", CompanyName = "DEF Corporation" }; sqlConnection.Execute( @" insert Suppliers(CompanyName, Address) values (@CompanyName, @Address) ", supplier); sqlConnection.Close(); Console.WriteLine("Done. "); } }
public static void Main() { using (var sqlConnection = new SqlConnection(Constant.DatabaseConnection)) { sqlConnection.Open(); var supplier = new Supplier() { Address = "10 Main Street", CompanyName = "ABC Corporation" }; var supplierId = sqlConnection.Insert<Supplier>(supplier); sqlConnection.Close(); Console.WriteLine(string.Format("New Supplier Id is {0}", supplierId)); Console.WriteLine("Done. "); } }