public static void InitDatabase(IDatabaseSettings dbSettings) { if (dbSettings.HasSettings()) { DotEntityDb.GlobalTableNamePrefix = TablePrefix; DotEntityDb.Initialize(dbSettings.ConnectionString, GetProvider(dbSettings.ProviderName)); } }
public void Init() { DotEntityDb.Initialize(SqliteConnectionString, new SqliteDatabaseProvider()); var createProduct = @"CREATE TABLE Product ( Id INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, ProductName TEXT NOT NULL, ProductDescription TEXT NULL, DateCreated TEXT NOT NULL, Price NUMERIC NOT NULL, IsActive NUMERIC NOT NULL);"; EntitySet.Query(createProduct, null); }
public void Init() { DotEntityDb.Initialize(MySqlConnectionString, new MySqlDatabaseProvider("mytest")); var createProduct = @"CREATE TABLE Product ( Id INT NOT NULL AUTO_INCREMENT, ProductName TEXT NOT NULL, ProductDescription TEXT NULL, DateCreated DATETIME NOT NULL, Price NUMERIC(18,0) NOT NULL, IsActive TINYINT(1) NOT NULL, PRIMARY KEY (Id));"; EntitySet.Query(createProduct, null); }
public static bool IsValidConnection(string providerName, string connectionString) { DotEntityDb.Initialize(connectionString, GetProvider(providerName)); try { DotEntityDb.Provider.Connection.Open(); return(true); } catch { return(false); } finally { DotEntityDb.Provider.Connection.Close(); } }
public void Init() { DotEntityDb.Initialize(MsSqlConnectionString, new SqlServerDatabaseProvider()); var createProduct = @"CREATE TABLE Product ( Id INT NOT NULL IDENTITY(1,1), ProductName NVARCHAR(MAX) NOT NULL, ProductDescription NVARCHAR(MAX) NULL, DateCreated DATETIME NOT NULL, Price NUMERIC(18,0) NOT NULL, IsActive BIT NOT NULL, PRIMARY KEY CLUSTERED (Id ASC));"; EntitySet.Query(createProduct, null); var createCategory = @"CREATE TABLE Category ( Id INT NOT NULL IDENTITY(1,1), CategoryName NVARCHAR(MAX) NOT NULL, CategoryType INT NOT NULL, PRIMARY KEY CLUSTERED (Id ASC));"; EntitySet.Query(createCategory, null); }
public MySqlQueryGenerationTests() { DotEntityDb.Initialize(MySqlConnectionString, new MySqlDatabaseProvider("mytest"), SelectQueryMode.Wildcard); generator = DotEntityDb.Provider.QueryGenerator; }
public void Setup() { BaseSetup(); DotEntityDb.Initialize(ConnectionString, new SqlServerDatabaseProvider()); _queryCache = EntitySet.GetQueryCache(); }
public SqlServerQueryGenerationTests() { DotEntityDb.Initialize(MsSqlConnectionString, new SqlServerDatabaseProvider(), SelectQueryMode.Wildcard); generator = DotEntityDb.Provider.QueryGenerator; }
public SqliteQueryGenerationTests() { DotEntityDb.Initialize(SqliteConnectionString, new SqliteDatabaseProvider(), SelectQueryMode.Wildcard); _generator = DotEntityDb.Provider.QueryGenerator; }