private void SaveChanges()
{
using (var db = new SqlConnection(ConnectionHelper.ConnectionString))
{
db.Open();
// not part of a single transaction. you can handle that on your own if important...
foreach (var changedContact in _vm.Contacts.Where(a => a.IsChanged))
{
var sp = new Sproc("Person.spUpdateExtensibleData", db);
sp.SetParam("@ContactId", changedContact.ContactId);
var fieldsInXml = CollectionHelper.GetExtensibleDataAsXml(changedContact);
sp.SetParam("@XmlFieldVals", fieldsInXml);
sp.ExecNonQuery();
}
}
}
private static List <Contact> GetCustomerData()
{
using (var db = new SqlConnection(ConnectionHelper.ConnectionString))
{
db.Open();
var sp = new Sproc("Person.spGetSomeContacts", db);
List <Contact> results;
sp.Execute(out results);
foreach (var contact in results)
{
var exsp = new Sproc("Person.spGetExtendedData", db);
exsp.SetParam("@ContactId", contact.ContactId);
List <ExtensibleDataItem> dataFields;
exsp.Execute(out dataFields);
CollectionHelper.UpdateObjectFromExtensibleData(dataFields, contact);
contact.AcceptChanges();
}
return(results);
}
}
static void Main(string[] args)
{
var fd = GetFlogDetail("starting application", null);
Flogger.WriteDiagnostic(fd);
var tracker = new PerfTracker("FloggerConsole_Execution", "", fd.UserName,
fd.Location, fd.Product, fd.Layer);
//try
//{
// var ex = new Exception("Something bad has happened!");
// ex.Data.Add("input param", "nothing to see here");
// throw ex;
//}
//catch (Exception ex)
//{
// fd = GetFlogDetail("", ex);
// Flogger.WriteError(fd);
//}
var connStr = ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString();
using (var db = new SqlConnection(connStr))
{
db.Open();
try
{
//RAW ADO.NET
//var rawAdoSp = new SqlCommand("CreateNewCustomer", db)
//{
// CommandType = System.Data.CommandType.StoredProcedure
//};
//rawAdoSp.Parameters.Add(new SqlParameter("@Name", "waytoolongforitsowngood"));
//rawAdoSp.Parameters.Add(new SqlParameter("@TotalPurchases", 12000));
//rawAdoSp.Parameters.Add(new SqlParameter("@TotalReturns", 100.50M));
//rawAdoSp.ExecuteNonQuery();
var sp = new Sproc(db, "CreateNewCustomer");
sp.SetParam("@Name", "waytoolongforitsowngood");
sp.SetParam("@TotalPurchases", 12000);
sp.SetParam("@TotalReturns", 100.50M);
sp.ExecNonQuery();
}
catch (Exception ex)
{
var efd = GetFlogDetail("", ex);
Flogger.WriteError(efd);
}
try
{
// Dapper
//db.Execute("CreateNewCustomer", new
//{
// Name = "dappernametoolongtowork",
// TotalPurchases = 12000,
// TotalReturns = 100.50M
//}, commandType: System.Data.CommandType.StoredProcedure);
// Wrapped Dapper
db.DapperProcNonQuery("CreateNewCustomer", new
{
Name = "dappernametoolongtowork",
TotalPurchases = 12000,
TotalReturns = 100.50M
});
}
catch (Exception ex)
{
var efd = GetFlogDetail("", ex);
Flogger.WriteError(efd);
}
}
var ctx = new CustomerDbContext();
try
{
// Entity Framework
var name = new SqlParameter("@Name", "waytoolongforitsowngood");
var totalPurchases = new SqlParameter("@TotalPurchases", 12000);
var totalReturns = new SqlParameter("@TotalReturns", 100.50M);
ctx.Database.ExecuteSqlCommand("EXEC dbo.CreateNewCustomer @Name, @TotalPurchases, @TotalReturns",
name, totalPurchases, totalReturns);
}
catch (Exception ex)
{
var efd = GetFlogDetail("", ex);
Flogger.WriteError(efd);
}
var customers = ctx.Customers.ToList();
fd = GetFlogDetail($"{customers.Count} customers in the database", null);
Flogger.WriteDiagnostic(fd);
fd = GetFlogDetail("used flogging console", null);
Flogger.WriteUsage(fd);
fd = GetFlogDetail("stopping app", null);
Flogger.WriteDiagnostic(fd);
tracker.Stop();
}