public static void Main() { string connectionString = ConfigurationManager.ConnectionStrings["database-connection-2"].ConnectionString; using (var sqlConnection = new SqlConnection(connectionString)) { sqlConnection.Open(); var db = NorthwindDatabase.Init(sqlConnection, commandTimeout: 3); var supplier = db.Suppliers.Get(9); // snapshotter tracks which fields change on the object var s = Snapshotter.Start(supplier); supplier.CompanyName += "_" + Guid.NewGuid().ToString().Substring(1, 4); db.Suppliers.Update(9, s.Diff()); // reload it from database supplier = db.Suppliers.Get(9); ObjectDumper.Write(supplier); } }
public static void Main() { string connectionString = ConfigurationManager.ConnectionStrings["database-connection-2"].ConnectionString; using (var sqlConnection = new SqlConnection(connectionString)) { sqlConnection.Open(); var db = NorthwindDatabase.Init(sqlConnection, commandTimeout: 2); int?supplierId = db.Suppliers.Insert(new { CompanyName = Guid.NewGuid().ToString() }); Console.WriteLine(string.Format("New Supplier Id is {0}", supplierId.Value)); } }
public static void Main() { string connectionString = ConfigurationManager.ConnectionStrings["database-connection-2"].ConnectionString; using (var sqlConnection = new SqlConnection(connectionString)) { sqlConnection.Open(); var db = NorthwindDatabase.Init(sqlConnection, commandTimeout: 2); var result = db.Suppliers.All(); foreach (var supplier in result) { ObjectDumper.Write(supplier); } } }