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