public static HOAProDBContainer CreateContext()
{
HOAProDBContainer context = null;
if (System.Reflection.Assembly.GetExecutingAssembly() != null)
{
string sdfFileLocation = System.Reflection.Assembly.GetExecutingAssembly().Location;
string sdfFilePath = null;
if(!string.IsNullOrWhiteSpace(sdfFileLocation))
sdfFilePath = Path.GetDirectoryName(sdfFileLocation);
if (!string.IsNullOrWhiteSpace(sdfFilePath))
{
sdfFilePath = !sdfFilePath.Trim().EndsWith(@"\") ? sdfFilePath.Trim() + @"\" : sdfFilePath.Trim();
sdfFilePath += @"Persistence\HOAPro.sdf";
if (System.IO.File.Exists(sdfFilePath))
{
//string providerConnectionString = @"metadata=res://*/Persistence.HOAPro.csdl|res://*/Persistence.HOAPro.ssdl|res://*/Persistence.HOAPro.msl;provider=System.Data.SqlServerCe.3.5;provider connection string=""Data Source=" + sdfFilePath + @""";";
string providerConnectionString = string.Format(@"metadata=res://*/Persistence.HOAPro.csdl|res://*/Persistence.HOAPro.ssdl|res://*/Persistence.HOAPro.msl;provider=System.Data.SqlServerCe.4.0;provider connection string=""Data Source={0}"";", sdfFilePath);
context = new HOAProDBContainer(providerConnectionString);
}
}
}
if (context == null)
context = new HOAProDBContainer();
return context;
}
public ManageHomesViewModel()
{
context = Persistence.Persistence.CreateContext();
Homes = context.Homes;
}
public ManageDuesYearsViewModel()
{
context = Persistence.Persistence.CreateContext();
this.DueYears = context.DueYears.ToObservableCollection();
}
