Devart Forums

Code: Select all

        private CrmDemoDataContext CreateContext(string path, bool deleteExisting)
        {
            bool fileExists = File.Exists(path);
            if (!fileExists || deleteExisting)
            {
                FileStream s = File.Create(path);  // create empty file
                s.Close();
            }
            CrmDemoDataContext db = new CrmDemoDataContext(string.Format("Data Source={0}", path));
            if (!fileExists || deleteExisting)
            {
                db.CreateDatabase();
            }
            return (db);
        }

        [TestMethod]
        public void CreateDb()
        {
            string path = @"E:\Dave\projects\EF\Devart\CRMTutorial\CRMDemo\CrmDemoTest\crm_test.db";
            using (CrmDemoDataContext db = CreateContext(path, true))
            {
                Assert.IsTrue(db.Companies.Count() == 0);
            }
        }

        [TestMethod]
        public void ReadDb()
        {
            string path = @"E:\Dave\projects\EF\Devart\CRMTutorial\crm_demo.db";
            using (CrmDemoDataContext db = CreateContext(path, false))
            {
                int nCompanies = db.Companies.Count();
                Assert.IsTrue(nCompanies > 0);
            }
        }