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