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