public static void SetDB(StorageFolder folder, string dbName, SqliteOption sqliteOption, Action creationDelegate)
{
bool createIfNotExists = (sqliteOption & SqliteOption.CreateIfNotExists) != 0;
bool createAlways = (sqliteOption & SqliteOption.CreateAlways) != 0;
bool exists = FileExists(folder, dbName);
if (createAlways && exists)
{
exists = false;
var task = folder.GetFileAsync(dbName).AsTask();
task.Wait();
task.Result.DeleteAsync().AsTask().Wait();
}
SetDB(new CSDataProviderSqliteWP8("uri=file://" + Path.Combine(folder.Path, dbName)), DEFAULT_CONTEXTNAME);
if (!exists && (createIfNotExists || createAlways) && creationDelegate != null)
{
creationDelegate();
}
}
public static void SetDB(string dbName, SqliteOption sqliteOption, Action creationDelegate)
{
bool exists = File.Exists(dbName);
bool createIfNotExists = (sqliteOption & SqliteOption.CreateIfNotExists) != 0;
bool usePooling = (sqliteOption & SqliteOption.UseConnectionPooling) != 0;
if (!exists && createIfNotExists)
SqliteConnection.CreateFile(dbName);
CSConfig.SetDB(new CSDataProviderSqlite("Data Source=" + dbName + ";Pooling=" + usePooling), CSConfig.DEFAULT_CONTEXTNAME);
if (!exists && createIfNotExists && creationDelegate != null)
creationDelegate();
}
public static void SetDB(string dbName, SqliteOption sqliteOption, Action creationDelegate)
{
bool exists = File.Exists(dbName);
bool createIfNotExists = (sqliteOption & SqliteOption.CreateIfNotExists) != 0;
bool usePooling = (sqliteOption & SqliteOption.UseConnectionPooling) != 0;
if (!exists && createIfNotExists)
{
SqliteConnection.CreateFile(dbName);
}
SetDB(new CSDataProviderSQLite("Data Source=" + dbName + ";Pooling=" + usePooling), DEFAULT_CONTEXTNAME);
if (!exists && createIfNotExists && creationDelegate != null)
{
creationDelegate();
}
}
public static void SetDB(string dbName, SqliteOption sqliteOption, Action creationDelegate)
{
IsolatedStorageFile isolatedStorageFile = IsolatedStorageFile.GetUserStoreForApplication();
bool createIfNotExists = (sqliteOption & SqliteOption.CreateIfNotExists) != 0;
bool createAlways = (sqliteOption & SqliteOption.CreateAlways) != 0;
bool exists = isolatedStorageFile.FileExists(dbName);
if (createAlways && exists)
{
exists = false;
isolatedStorageFile.DeleteFile(dbName);
}
SetDB(new CSDataProviderSqliteWP7("uri=file://" + dbName), DEFAULT_CONTEXTNAME);
if (!exists && (createIfNotExists || createAlways) && creationDelegate != null)
creationDelegate();
}
public static void SetDB(string dbName, SqliteOption sqliteOption, Action creationDelegate)
{
IsolatedStorageFile isolatedStorageFile = IsolatedStorageFile.GetUserStoreForApplication();
bool createIfNotExists = (sqliteOption & SqliteOption.CreateIfNotExists) != 0;
bool createAlways = (sqliteOption & SqliteOption.CreateAlways) != 0;
bool exists = isolatedStorageFile.FileExists(dbName);
if (createAlways && exists)
{
exists = false;
isolatedStorageFile.DeleteFile(dbName);
}
SetDB(new CSDataProviderSqliteWP7("uri=file://" + dbName), DEFAULT_CONTEXTNAME);
if (!exists && (createIfNotExists || createAlways) && creationDelegate != null)
{
creationDelegate();
}
}
public static void SetDB(StorageFolder folder, string dbName, SqliteOption sqliteOption, Action creationDelegate)
{
bool createIfNotExists = (sqliteOption & SqliteOption.CreateIfNotExists) != 0;
bool createAlways = (sqliteOption & SqliteOption.CreateAlways) != 0;
bool exists = FileExists(folder,dbName);
if (createAlways && exists)
{
exists = false;
var task = folder.GetFileAsync(dbName).AsTask();
task.Wait();
task.Result.DeleteAsync().AsTask().Wait();
}
SetDB(new CSDataProviderSqliteWP8("uri=file://" + Path.Combine(folder.Path,dbName)), DEFAULT_CONTEXTNAME);
if (!exists && (createIfNotExists || createAlways) && creationDelegate != null)
creationDelegate();
}
public static void SetDB(string dbName, SqliteOption sqliteOption)
{
SetDB(dbName, sqliteOption, null);
}
public static void SetDB(string dbName, SqliteOption sqliteOption)
{
SetDB(dbName,sqliteOption,null);
}
public static void SetDB(string dbName, SqliteOption sqliteOption, Action creationDelegate)
{
SetDB(ApplicationData.Current.LocalFolder, dbName, sqliteOption, creationDelegate);
}
public static void SetDB(string dbName, SqliteOption sqliteOption, Action creationDelegate)
{
SetDB(ApplicationData.Current.LocalFolder,dbName,sqliteOption,creationDelegate);
}
