private void button1_Click(object sender, EventArgs e) { Assembly assemblyInfo = Assembly.GetExecutingAssembly(); //Location is where the assembly is run from //CodeBase is the location of the ClickOnce deployment files var uriCodeBase = new Uri(assemblyInfo.CodeBase); var _clickOnceLocation = Path.GetDirectoryName(uriCodeBase.LocalPath); var _localdb = new DbInstance(_clickOnceLocation + @"/data"); _localdb.Map <CifInfo>().Automap(i => i.cifno); _localdb.Initialize(); dlgocEntities dl = new dlgocEntities(); var ds = dl.getCIFInfo(); var lm = (from p in dl.LOANMONTHs where p.Datadate == new DateTime(2018, 12, 31) select new { p.CIFNO, p.ACNAME }).Distinct(); foreach (var i in lm) { richTextBox1.AppendText(i.CIFNO + "\n"); _localdb.Save(new CifInfo() { cifno = (decimal)i.CIFNO, acname = i.ACNAME }); } _localdb.Compact(); }