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. ");
}
}