So what about creating new instances of POCO in DBMS or deleting it? No problem. You need to create and save it.
static void Main(string[] args)
{
//create new instance
Sales.SalesTerritory t = new exam1sharp.Sales.SalesTerritory()
{
Name = "China",
CountryRegionCode = "CH",
Group = "Asia",
SalesYTD = 100,
SalesLastYear = 100,
ModifiedDate = DateTime.Now
};
//save new instance
using (ModificationsTracker mt = new ModificationsTracker(exam1sharp.Properties.Settings.Default.connString))
{
mt.Add(t);
mt.AcceptModifications();
}
Console.WriteLine("New SalesTerritory id = {0}", t.ID);
//delete created instance
using (ModificationsTracker mt = new ModificationsTracker(exam1sharp.Properties.Settings.Default.connString))
{
mt.Delete(t);
mt.AcceptModifications();
}
}