public void GetFromServer()
{
AdventureWorksLTDbContext db = null;
try {
using (db = new AdventureWorksLTDbContext()) {
Customers = new ObservableCollection <Customer>(db.Customers);
}
}
catch (Exception ex) {
ResultText = ex.ToString();
}
}
public void GetFromServer()
{
AdventureWorksLTDbContext db = null;
try {
using (db = new AdventureWorksLTDbContext()) {
Customers = new ObservableCollection <Customer>(db.Customers);
}
ResultText += "Read from Customers table on SQL Server" + Environment.NewLine;
}
catch (Exception ex) {
ResultText = ex.ToString();
}
}
public void GetServerInfo()
{
DateTime ret = DateTime.MinValue;
AdventureWorksLTDbContext db = null;
ServerMaxDate = DateTime.MinValue;
ServerTotalRows = -1;
try {
using (db = new AdventureWorksLTDbContext()) {
// Get maximum date in ModifiedDate field
ServerMaxDate = db.Customers.OrderByDescending(c => c.ModifiedDate)
.Select(c => c.ModifiedDate).FirstOrDefault();
// Get total rows in the Customer table on the server
ServerTotalRows = db.Customers.Count();
ResultText += "Server Max Date: " + ServerMaxDate.ToString() + Environment.NewLine;
ResultText += "Server Total Rows: " + ServerTotalRows.ToString() + Environment.NewLine;
}
}
catch (Exception ex) {
ResultText = ex.ToString();
}
}
