C# (CSharp) SqlCeTools Examples

Example #1

 public ApplicantsDbContext() : base(SqlCeTools.GetDataProvider(), string.Format("Data Source={0}", _dbFileName))
 {
     if (File.Exists(_dbFileName) == false)
     {
         SqlCeTools.CreateDatabase(_dbFileName);
         this.CreateTable <Applicant>();
     }
 }

Example #2

File: SqlCeTests.cs Project: Mitch528/linq2db

        public void CreateDatabase(string context)
        {
            SqlCeTools.CreateDatabase("TestDatabase");
            Assert.IsTrue(File.Exists("TestDatabase.sdf"));

            using (var db = new DataConnection(SqlCeTools.GetDataProvider(), "Data Source=TestDatabase.sdf"))
            {
                db.CreateTable <CreateTableTest>();
                db.DropTable <CreateTableTest>();
            }

            SqlCeTools.DropDatabase("TestDatabase");
            Assert.IsFalse(File.Exists("TestDatabase.sdf"));
        }

Example #3

File: SqlCeTests.cs Project: marcosdiez/linq2db

 public void CreateDatabase(string context)
 {
     SqlCeTools.CreateDatabase("TestDatabase");
     Assert.IsTrue(File.Exists("TestDatabase.sdf"));
     SqlCeTools.DropDatabase("TestDatabase");
 }