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(); } }