public void Refresh() { db = main.GetDBContext(); var cList = db.CringleDetails.ToList(); CringleList = new ObservableCollection <Model.CringleDetail>(cList); }
public void Refresh() { db = main.GetDBContext(); PeopleList = new ObservableCollection <Model.Person>(db.People.ToList()); foreach (var p in PeopleList) { p.db = db; } AddDefaultItem(); }
protected virtual void Dispose(bool disposing) { if (disposing) { // free managed resources if (db != null) { db.Dispose(); db = null; } } }
public void OpenFile(String fileName) { try { System.Data.SQLite.SQLiteConnectionStringBuilder dbBuild = new System.Data.SQLite.SQLiteConnectionStringBuilder(); dbBuild.DataSource = fileName; string connString = "Provider=System.Data.SQLite;" + dbBuild.ToString(); var conn = new System.Data.SQLite.SQLiteConnection(dbBuild.ToString()); //Test Connection (kinda crap way but hey) using (var context = new Model.XMusCringleContext(conn, true)) { var c = context.People.ToList(); } main.dbConnString = connString; } catch (Exception e) { main.dbConnString = null; } }