/// <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 void CleanProducts()
{
using (System.Data.SqlServerCe.SqlCeConnection conn =
new System.Data.SqlServerCe.SqlCeConnection(
Program.Default.ProductsConnectionString))
{
conn.Open();
using (System.Data.SqlServerCe.SqlCeCommand cmd
= new System.Data.SqlServerCe.SqlCeCommand())
{
cmd.Connection = conn;
cmd.CommandText = "delete from productsBinTbl";
cmd.ExecuteNonQuery();
cmd.CommandText = "delete from productsTbl";
cmd.ExecuteNonQuery();
}
this.ProductsTbl.Clear();
this.ProductsBinTbl.Clear();
this.AcceptChanges();
}
using (System.Data.SqlServerCe.SqlCeEngine engine
= new System.Data.SqlServerCe.SqlCeEngine(Program.Default.ProductsConnectionString))
{
engine.Shrink();
}
}
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 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 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();
}
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>
/// Set up the SQL connections for the table adapters when creating/opening
/// a database.
/// </summary>
private void CreateConnections()
{
localDB = new DPDatabaseImportV1();
localTAManager = new DPDatabaseImportV1TableAdapters.TableAdapterManager();
localTAManager.ChatLogTableAdapter = new DPDatabaseImportV1TableAdapters.ChatLogTableAdapter();
// DVS/DirectParse uses SQLCE 3.1, so we can always do an upgrade here.
System.Data.SqlServerCe.SqlCeEngine sqlCeEngine = new System.Data.SqlServerCe.SqlCeEngine(databaseConnectionString);
// Creates a 0-byte file. We need the name, but don't want the file to exist.
tempDatabaseName = Path.GetTempFileName();
File.Delete(tempDatabaseName);
string tempConnectionString = string.Format("Data Source={0}", tempDatabaseName);
sqlCeEngine.Upgrade(tempConnectionString);
Properties.Settings.Default.Properties["DvsParse_SaveConnectionString"].DefaultValue = tempConnectionString;
System.Data.SqlServerCe.SqlCeConnection sqlConn =
new System.Data.SqlServerCe.SqlCeConnection(tempConnectionString);
localTAManager.Connection = sqlConn;
localTAManager.ChatLogTableAdapter.Connection = sqlConn;
localTAManager.ChatLogTableAdapter.Fill(localDB.ChatLog);
}
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);
}
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);
}
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();
}
/// <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;
}
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();
}
}
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();
}
}
private static void Spike_SqlServerCe_Upgrade_To_Current(string[] args)
{
var e = new System.Data.SqlServerCe.SqlCeEngine(Nespe.Data.Context.NespeDataContext.ConnectionString);
e.Upgrade();
}
/// <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);
}
protected override void OnStartup(StartupEventArgs e)
{
var key = Microsoft.Win32.Registry.LocalMachine.OpenSubKey(@"SOFTWARE\Microsoft\Microsoft SQL Server Compact Edition\v4.0", false);
if (key == null) // || Util.Parse<int>(key.GetValue("ServicePackLevel")) < 2)
{
throw new Exception(Labels.AppRequiresSql);
}
key = Microsoft.Win32.Registry.LocalMachine.OpenSubKey(@"SOFTWARE\Microsoft\Office");
bool found = false;
if (key != null)
{
string[] versions = key.GetSubKeyNames().Where(v => Util.Parse <double>(v) >= 10).ToArray();
foreach (string v in versions)
{
key = Microsoft.Win32.Registry.LocalMachine.OpenSubKey(@"SOFTWARE\Microsoft\Office\" + v + @"\PowerPoint\InstallRoot", false);
if (key != null && !String.IsNullOrEmpty(key.GetValue("Path") as string))
{
found = true;
}
}
}
if (!found)
{
key = Microsoft.Win32.Registry.LocalMachine.OpenSubKey(@"SOFTWARE\Wow6432Node\Microsoft\Office");
if (key == null)
{
throw new Exception(Labels.AppRequiresOffice);
}
string[] versions = key.GetSubKeyNames().Where(v => Util.Parse <double>(v) >= 10).ToArray();
foreach (string v in versions)
{
key = Microsoft.Win32.Registry.LocalMachine.OpenSubKey(@"SOFTWARE\Wow6432Node\Microsoft\Office\" + v + @"\PowerPoint\InstallRoot", false);
if (key != null && !String.IsNullOrEmpty(key.GetValue("Path") as string))
{
found = true;
}
}
}
if (!found)
{
throw new Exception(Labels.AppRequiresOffice);
}
Config.FontSize = Util.Parse <double?>(ConfigurationManager.AppSettings["FontSize"]) ?? SystemFonts.MessageFontSize;
base.OnStartup(e);
//accessing database causes 3 or 4 sec delay so place in background thread, useful preloading for when planner is opened
new Action(() =>
{
//determine if it's a new installation by whether there are any schedules loaded or not
//if Presenter 0.9.9, will be running sql compact 3.5 that will need to be upgraded to 4.0
bool isnew = true;
try { isnew = !Schedule.LoadSchedules().Any(); }
catch (Exception ex)
{
if (ex.GetBaseException().Message == "The database file has been created by an earlier version of SQL Server Compact. Please upgrade using SqlCeEngine.Upgrade() method.")
{
var engine = new System.Data.SqlServerCe.SqlCeEngine(ConfigurationManager.ConnectionStrings["DatabaseConnectionString"].ConnectionString);
engine.Upgrade();
engine.Compact(null);
isnew = !Schedule.LoadSchedules().Any();
}
else
{
throw ex;
}
}
//gives warning that videos won't work without WMP10, not a requirement so only display if a new installation
if (isnew)
{
key = Microsoft.Win32.Registry.LocalMachine.OpenSubKey(@"SOFTWARE\Microsoft\MediaPlayer\PlayerUpgrade", false);
if (key == null || Util.Parse <int>((key.GetValue("PlayerVersion") ?? "").ToString().Split(',').FirstOrDefault()) < 10)
{
if (!Application.Current.Dispatcher.CheckAccess())
{
Application.Current.Dispatcher.Invoke(new Action(() => { MessageBox.Show(MainWindow, Labels.AppRequiresWMP, "", MessageBoxButton.OK, MessageBoxImage.Exclamation); }));
}
}
}
}).BeginInvoke(null, null);
}
/// <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;
}
public void Create(string connectionString)
{
using var engine = new System.Data.SqlServerCe.SqlCeEngine(connectionString);
engine.CreateDatabase();
}
