public static void Bootstrap()
{
string appPath = Path.GetDirectoryName(Application.ExecutablePath);
var cnxString = ConfigurationManager.ConnectionStrings["MediaApp.Properties.Settings.MediaConnectionString"].ConnectionString;
var dbPath = appPath + "\\Media.sdf";
var configuration = Fluently.Configure()
.Database(MsSqlCeConfiguration.Standard.ShowSql().ConnectionString(cnxString))
.Search(s =>
s.DefaultAnalyzer().Standard()
.DirectoryProvider().FSDirectory()
.IndexBase(appPath + "\\SearchIndex")
.IndexingStrategy().Event()
.Listeners(ListenerConfiguration.Default)
.MappingClass <SearchMap>()
)
.Mappings(m => m.FluentMappings.AddFromAssemblyOf <Film>()
.Conventions.AddFromAssemblyOf <Film>()
);
if (!File.Exists(dbPath))
{
var engine = new System.Data.SqlServerCe.SqlCeEngine(cnxString);
engine.CreateDatabase();
configuration.ExposeConfiguration(c => new SchemaExport(c).Create(false, true));
}
_sessionFactory = configuration.BuildSessionFactory();
}
/// <summary>
/// Creates the database
/// </summary>
public static int CreateDatabase()
{
int resultCount = 0;
using (var engine = new System.Data.SqlServerCe.SqlCeEngine(EntityBase.ConnectionString))
engine.CreateDatabase();
using (var transaction = EntityBase.Connection.BeginTransaction())
using (var command = EntityBase.CreateCommand(transaction))
{
command.CommandText = "CREATE TABLE [Contact](Id INT IDENTITY(1,1) PRIMARY KEY NOT NULL, Name NVARCHAR(100), Address NVARCHAR(100), City NVARCHAR(100), PostalCode NVARCHAR(100), Country NVARCHAR(100), Email NVARCHAR(100), Phone NVARCHAR(100))";
resultCount += command.ExecuteNonQuery();
command.CommandText = "CREATE TABLE [Customer](Id INT IDENTITY(1,1) PRIMARY KEY NOT NULL, ContactId INT, Name NVARCHAR(100), Address NVARCHAR(100), City NVARCHAR(100), PostalCode NVARCHAR(100), Country NVARCHAR(100), Email NVARCHAR(100), Phone NVARCHAR(100), Fax NVARCHAR(100))";
resultCount += command.ExecuteNonQuery();
command.CommandText = "CREATE TABLE [Product](Id INT IDENTITY(1,1) PRIMARY KEY NOT NULL, PartNumber NVARCHAR(100), Ean13 NVARCHAR(100), Name NVARCHAR(100), Description NVARCHAR(100), Rating NUMERIC)";
resultCount += command.ExecuteNonQuery();
command.CommandText = "CREATE TABLE [Stock](Id INT IDENTITY(1,1) PRIMARY KEY NOT NULL, ProductId INT, Quantity INT, LastUpdated DATETIME)";
resultCount += command.ExecuteNonQuery();
transaction.Commit();
}
return(resultCount);
}
public static void MyClassInitialize(TestContext testContext)
{
XmlConfigurator.ConfigureAndWatch(new FileInfo(Util.LogConfigFilePath));
if (File.Exists("Test.sdf")) File.Delete("Test.sdf");
using (var engine = new System.Data.SqlServerCe.SqlCeEngine(ConnectionString))
{
engine.CreateDatabase();
}
var cnf = Fluently.Configure()
.Database(MsSqlCeConfiguration.Standard
.ConnectionString(((ConnectionStringBuilder cs) => cs.Is(ConnectionString)))
.Dialect<MsSqlCe40Dialect>())
.Mappings(mappings => mappings.FluentMappings.AddFromAssembly(typeof(Order).Assembly).ExportTo("."))
.ExposeConfiguration(x => new SchemaExport(x).Execute(false, true, false));//, GetConnection(), null));
//var config = cnf.BuildConfiguration()
// .SetProperty(NHibernateCfg.Environment.ReleaseConnections, "on_close");
_ordersFactory = cnf.BuildConfiguration().BuildSessionFactory();
cnf = Fluently.Configure()
.Database(MsSqlCeConfiguration.Standard
.ConnectionString(((ConnectionStringBuilder cs) => cs.Is(ConnectionString)))
.Dialect<MsSqlCe40Dialect>())
.Mappings(mappings => mappings.FluentMappings.AddFromAssembly(typeof(SalesPerson).Assembly).ExportTo("."))
.ExposeConfiguration(x => new SchemaExport(x).Execute(false, true, false));//, GetConnection(), null));
//config = cnf.BuildConfiguration()
// .SetProperty(NHibernateCfg.Environment.ReleaseConnections, "on_close");
_hrFactory = cnf.BuildConfiguration().BuildSessionFactory();
}
protected override FluentNHibernate.Cfg.Db.IPersistenceConfigurer GetDbConfig(string connectionString)
{
var dataSource = connectionString.Split(';')
.Select(x => x.Split(new char[] { '=' }, 2))
.Where(x => x[0].Trim() == "Data Source")
.Select(x => x[1])
.FirstOrDefault();
if (dataSource.EndsWith(".sdf"))
{
var dir = AppDomain.CurrentDomain.GetData("DataDirectory").ToString();
var dbFile = dataSource.Replace("|DataDirectory|", dir);
//we want a sqlce db in here
if (!File.Exists(dbFile))//if file doesn't exist then create it
{
var engine = new System.Data.SqlServerCe.SqlCeEngine(connectionString);
engine.CreateDatabase();
}
return MsSqlCeConfiguration.Standard.ConnectionString(connectionString);
}
else
{
return base.GetDbConfig(connectionString);
}
}
public static void Bootstrap()
{
string appPath = Path.GetDirectoryName(Application.ExecutablePath);
var cnxString = ConfigurationManager.ConnectionStrings["MediaApp.Properties.Settings.MediaConnectionString"].ConnectionString;
var dbPath = appPath + "\\Media.sdf";
var configuration = Fluently.Configure()
.Database(MsSqlCeConfiguration.Standard.ShowSql().ConnectionString(cnxString))
.Search(s =>
s.DefaultAnalyzer().Standard()
.DirectoryProvider().FSDirectory()
.IndexBase(appPath + "\\SearchIndex")
.IndexingStrategy().Event()
.Listeners(ListenerConfiguration.Default)
.MappingClass<SearchMap>()
)
.Mappings(m => m.FluentMappings.AddFromAssemblyOf<Film>()
.Conventions.AddFromAssemblyOf<Film>()
);
if (!File.Exists(dbPath))
{
var engine = new System.Data.SqlServerCe.SqlCeEngine(cnxString);
engine.CreateDatabase();
configuration.ExposeConfiguration(c => new SchemaExport(c).Create(false, true));
}
_sessionFactory = configuration.BuildSessionFactory();
}
protected override void CreateDatabase()
{
var connstring = "Data Source=" + FileName;
using (var engine = new System.Data.SqlServerCe.SqlCeEngine(connstring))
{
engine.CreateDatabase();
}
}
//protected ISession OrdersDomainSession { get; set; }
//protected ISession HRDomainSession { get; set; }
public static void Setup()
{
if (File.Exists("Test.sdf")) File.Delete("Test.sdf");
using (var engine = new System.Data.SqlServerCe.SqlCeEngine(ConnectionString))
{
engine.CreateDatabase();
}
var cnf = Fluently.Configure()
.Database(MsSqlCeConfiguration.Standard
.ConnectionString(((ConnectionStringBuilder cs) => cs.Is(ConnectionString)))
.Dialect <MsSqlCe40Dialect>())
.Mappings(mappings => mappings.FluentMappings.AddFromAssembly(typeof(Order).Assembly).ExportTo("."))
.ExposeConfiguration(x => new SchemaExport(x).Execute(false, true, false));//, GetConnection(), null));
//var config = cnf.BuildConfiguration()
// .SetProperty(NHibernateCfg.Environment.ReleaseConnections, "on_close");
OrdersDomainFactory = cnf.BuildConfiguration().BuildSessionFactory();
cnf = Fluently.Configure()
.Database(MsSqlCeConfiguration.Standard
.ConnectionString(((ConnectionStringBuilder cs) => cs.Is(ConnectionString)))
.Dialect <MsSqlCe40Dialect>())
.Mappings(mappings => mappings.FluentMappings.AddFromAssembly(typeof(SalesPerson).Assembly).ExportTo("."))
.ExposeConfiguration(x => new SchemaExport(x).Execute(false, true, false));//, GetConnection(), null));
//config = cnf.BuildConfiguration()
// .SetProperty(NHibernateCfg.Environment.ReleaseConnections, "on_close");
HRDomainFactory = cnf.BuildConfiguration().BuildSessionFactory();
//OrdersDomainSession = OrdersDomainFactory.OpenSession(GetConnection());
//HRDomainSession = HRDomainFactory.OpenSession(GetConnection());
NHUnitOfWorkFactory unitOfWorkFactory = new NHUnitOfWorkFactory();
unitOfWorkFactory.RegisterSessionFactoryProvider(() => OrdersDomainFactory);
unitOfWorkFactory.RegisterSessionFactoryProvider(() => HRDomainFactory);
UnitOfWorkSettings.DefaultIsolation = System.Transactions.IsolationLevel.ReadCommitted;
//IUnitOfWork uow = UnitOfWorkFactory.Create();
var dependencyResolverFactory = new Mock<IDependencyResolverFactory>();
var dependencyResolver = new Mock<ICustomDependencyResolver>();
var logFacotry = new Mock<ILogFactory>();
var cacheManager = new Mock<ICacheManager>();
dependencyResolverFactory.Setup(x => x.CreateInstance()).Returns(dependencyResolver.Object);
dependencyResolver.Setup(x => x.GetService(typeof(ILogFactory))).Returns(logFacotry.Object);
dependencyResolver.Setup(x => x.GetService(typeof(ICacheManager), It.IsAny<string>())).Returns(cacheManager.Object);
dependencyResolver.Setup(x => x.GetService(typeof(IUnitOfWorkFactory))).Returns(unitOfWorkFactory);
//cacheManager.Setup(x => x.Get<IUnitOfWork>(It.IsAny<string>())).Returns(uow);
IoC.InitializeWith(dependencyResolverFactory.Object);
App.Data.TransactionManager transactionManager = new Data.TransactionManager();
cacheManager.Setup(x => x.Get<ITransactionManager>(It.IsAny<string>())).Returns(transactionManager);
}
public static void Bootstrap()
{
var cnxString = Properties.Settings.Default.ConnectionString;
const string dbPath = "Media.sdf";
var configuration = Fluently.Configure()
.Database(MsSqlCeConfiguration.Standard.ShowSql().ConnectionString(cnxString))
.Mappings(m => m.FluentMappings.AddFromAssemblyOf<Film>()
.Conventions.AddFromAssemblyOf<Film>());
if (!File.Exists(dbPath))
{
var engine = new System.Data.SqlServerCe.SqlCeEngine(cnxString);
engine.CreateDatabase();
configuration.ExposeConfiguration(c => new SchemaExport(c).Create(false, true));
}
_sessionFactory = configuration.BuildSessionFactory();
}
protected override void DbCreateConnection()
{
try
{
this.DbSetDateFormat = "set dateformat ymd";
this.DbReturnLastID = "select @@identity";
if (!System.IO.File.Exists(DatabaseFile))
{
System.Data.SqlServerCe.SqlCeEngine engine = new System.Data.SqlServerCe.SqlCeEngine(ConnectionString);
engine.CreateDatabase();
}
this.DbConnection = new System.Data.SqlServerCe.SqlCeConnection(ConnectionString);
}
catch (Exception ex)
{ throw new Exception("Erro ao criar a conexão com o driver", ex); }
}
/// <summary>
/// Creates the database
/// </summary>
public static int CreateDatabase()
{
int resultCount = 0;
using (var engine = new System.Data.SqlServerCe.SqlCeEngine(EntityBase.ConnectionString))
engine.CreateDatabase();
using (var transaction = EntityBase.Connection.BeginTransaction())
using (var command = EntityBase.CreateCommand(transaction))
{
command.CommandText = "CREATE TABLE [EnglishSentences](ID INT IDENTITY(1,1) PRIMARY KEY NOT NULL, Content NVARCHAR(100), Level INT)";
resultCount += command.ExecuteNonQuery();
transaction.Commit();
}
return(resultCount);
}
/// <summary>
/// Creates the database
/// </summary>
public static int CreateDatabase()
{
int resultCount = 0;
using (var engine = new System.Data.SqlServerCe.SqlCeEngine(EntityBase.ConnectionString))
engine.CreateDatabase();
using (var transaction = EntityBase.Connection.BeginTransaction())
using (var command = EntityBase.CreateCommand(transaction))
{
command.CommandText = "CREATE TABLE [EnglishSentences](ID INT IDENTITY(1,1) PRIMARY KEY NOT NULL, Content NVARCHAR(100), Level INT)";
resultCount += command.ExecuteNonQuery();
transaction.Commit();
}
return resultCount;
}
public static bool CreateDatabase(string path)
{
System.Data.SqlServerCe.SqlCeEngine dbEngine = new System.Data.SqlServerCe.SqlCeEngine("Data Source='" + path + "'");
try
{
dbEngine.CreateDatabase();
return true;
}
catch (System.Data.SqlServerCe.SqlCeException e)
{
// error #25114 - База уже есть
MessageBox.Show(e.Message, "db error #" + e.NativeError, MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
return false;
}
finally
{
dbEngine.Dispose();
}
}
static public bool CreateDatabase(string path)
{
System.Data.SqlServerCe.SqlCeEngine dbEngine = new System.Data.SqlServerCe.SqlCeEngine("Data Source='" + path + "'");
try
{
dbEngine.CreateDatabase();
return(true);
}
catch (System.Data.SqlServerCe.SqlCeException e)
{
// error #25114 - База уже есть
MessageBox.Show(e.Message, "db error #" + e.NativeError, MessageBoxButtons.OK, MessageBoxIcon.Exclamation, MessageBoxDefaultButton.Button1);
return(false);
}
finally
{
dbEngine.Dispose();
}
}
/// <summary>
/// inits connection to server
/// </summary>
/// <returns></returns>
public bool Initialize()
{
if(!Initialized)
{
#region prepare mssql & cache table
try
{
// precrete dir
if(!Directory.Exists(gtileCache))
{
Directory.CreateDirectory(gtileCache);
}
string connectionString = string.Format("Data Source={0}Data.sdf", gtileCache);
if(!File.Exists(gtileCache + "Data.sdf"))
{
using(System.Data.SqlServerCe.SqlCeEngine engine = new System.Data.SqlServerCe.SqlCeEngine(connectionString))
{
engine.CreateDatabase();
}
try
{
using(SqlConnection c = new SqlConnection(connectionString))
{
c.Open();
using(SqlCommand cmd = new SqlCommand(
"CREATE TABLE [GMapNETcache] ( \n"
+ " [Type] [int] NOT NULL, \n"
+ " [Zoom] [int] NOT NULL, \n"
+ " [X] [int] NOT NULL, \n"
+ " [Y] [int] NOT NULL, \n"
+ " [Tile] [image] NOT NULL, \n"
+ " CONSTRAINT [PK_GMapNETcache] PRIMARY KEY (Type, Zoom, X, Y) \n"
+ ")", c))
{
cmd.ExecuteNonQuery();
}
}
}
catch(Exception ex)
{
try
{
File.Delete(gtileCache + "Data.sdf");
}
catch
{
}
throw ex;
}
}
// different connections so the multi-thread inserts and selects don't collide on open readers.
this.cnGet = new SqlConnection(connectionString);
this.cnGet.Open();
this.cnSet = new SqlConnection(connectionString);
this.cnSet.Open();
this.cmdFetch = new SqlCommand("SELECT [Tile] FROM [GMapNETcache] WITH (NOLOCK) WHERE [X]=@x AND [Y]=@y AND [Zoom]=@zoom AND [Type]=@type", cnGet);
this.cmdFetch.Parameters.Add("@x", System.Data.SqlDbType.Int);
this.cmdFetch.Parameters.Add("@y", System.Data.SqlDbType.Int);
this.cmdFetch.Parameters.Add("@zoom", System.Data.SqlDbType.Int);
this.cmdFetch.Parameters.Add("@type", System.Data.SqlDbType.Int);
this.cmdFetch.Prepare();
this.cmdInsert = new SqlCommand("INSERT INTO [GMapNETcache] ( [X], [Y], [Zoom], [Type], [Tile] ) VALUES ( @x, @y, @zoom, @type, @tile )", cnSet);
this.cmdInsert.Parameters.Add("@x", System.Data.SqlDbType.Int);
this.cmdInsert.Parameters.Add("@y", System.Data.SqlDbType.Int);
this.cmdInsert.Parameters.Add("@zoom", System.Data.SqlDbType.Int);
this.cmdInsert.Parameters.Add("@type", System.Data.SqlDbType.Int);
this.cmdInsert.Parameters.Add("@tile", System.Data.SqlDbType.Image); //, calcmaximgsize);
//can't prepare insert because of the IMAGE field having a variable size. Could set it to some 'maximum' size?
Initialized = true;
}
catch(Exception ex)
{
Initialized = false;
Debug.WriteLine(ex.Message);
}
#endregion
}
return Initialized;
}
/// <summary>
/// inits connection to server
/// </summary>
/// <returns></returns>
public bool Initialize()
{
if (!Initialized)
{
#region prepare mssql & cache table
try
{
// precrete dir
if (!Directory.Exists(gtileCache))
{
Directory.CreateDirectory(gtileCache);
}
string connectionString = string.Format("Data Source={0}Data.sdf", gtileCache);
if (!File.Exists(gtileCache + "Data.sdf"))
{
using (System.Data.SqlServerCe.SqlCeEngine engine = new System.Data.SqlServerCe.SqlCeEngine(connectionString))
{
engine.CreateDatabase();
}
try
{
using (SqlConnection c = new SqlConnection(connectionString))
{
c.Open();
using (SqlCommand cmd = new SqlCommand(
"CREATE TABLE [GMapNETcache] ( \n"
+ " [Type] [int] NOT NULL, \n"
+ " [Zoom] [int] NOT NULL, \n"
+ " [X] [int] NOT NULL, \n"
+ " [Y] [int] NOT NULL, \n"
+ " [Tile] [image] NOT NULL, \n"
+ " CONSTRAINT [PK_GMapNETcache] PRIMARY KEY (Type, Zoom, X, Y) \n"
+ ")", c))
{
cmd.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
try
{
File.Delete(gtileCache + "Data.sdf");
}
catch
{
}
throw ex;
}
}
// different connections so the multi-thread inserts and selects don't collide on open readers.
this.cnGet = new SqlConnection(connectionString);
this.cnGet.Open();
this.cnSet = new SqlConnection(connectionString);
this.cnSet.Open();
this.cmdFetch = new SqlCommand("SELECT [Tile] FROM [GMapNETcache] WITH (NOLOCK) WHERE [X]=@x AND [Y]=@y AND [Zoom]=@zoom AND [Type]=@type", cnGet);
this.cmdFetch.Parameters.Add("@x", System.Data.SqlDbType.Int);
this.cmdFetch.Parameters.Add("@y", System.Data.SqlDbType.Int);
this.cmdFetch.Parameters.Add("@zoom", System.Data.SqlDbType.Int);
this.cmdFetch.Parameters.Add("@type", System.Data.SqlDbType.Int);
this.cmdFetch.Prepare();
this.cmdInsert = new SqlCommand("INSERT INTO [GMapNETcache] ( [X], [Y], [Zoom], [Type], [Tile] ) VALUES ( @x, @y, @zoom, @type, @tile )", cnSet);
this.cmdInsert.Parameters.Add("@x", System.Data.SqlDbType.Int);
this.cmdInsert.Parameters.Add("@y", System.Data.SqlDbType.Int);
this.cmdInsert.Parameters.Add("@zoom", System.Data.SqlDbType.Int);
this.cmdInsert.Parameters.Add("@type", System.Data.SqlDbType.Int);
this.cmdInsert.Parameters.Add("@tile", System.Data.SqlDbType.Image); //, calcmaximgsize);
//can't prepare insert because of the IMAGE field having a variable size. Could set it to some 'maximum' size?
Initialized = true;
}
catch (Exception ex)
{
Initialized = false;
}
#endregion
}
return(Initialized);
}
public void Create(string connectionString)
{
using var engine = new System.Data.SqlServerCe.SqlCeEngine(connectionString);
engine.CreateDatabase();
}