public static void Startup()
{
SQLiteConnection connection = null;
string dbLocation = "expensesDB.db3";
#if __ANDROID__
var library = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
dbLocation = Path.Combine(library, dbLocation);
var platform = new SQLitePlatformAndroid();
connection = new SQLiteConnection(platform, dbLocation);
#elif __IOS__
CurrentPlatform.Init();
var docsPath = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
var libraryPath = Path.Combine(docsPath, "../Library/");
dbLocation = Path.Combine(libraryPath, dbLocation);
var platform = new SQLitePlatformIOS();
connection = new SQLiteConnection(platform, dbLocation);
#elif WINDOWS_PHONE
var platform = new SQLitePlatformWP8();
dbLocation = Path.Combine(ApplicationData.Current.LocalFolder.Path, dbLocation);
connection = new SQLiteConnection(platform, dbLocation);
#endif
ServiceContainer.Register<IMessageDialog>(() => new MessageDialog());
ServiceContainer.Register<ICloudService>(AzureService.Instance);
ServiceContainer.Register<IExpenseService>(() => new ExpenseService(connection));
ServiceContainer.Register<ExpensesViewModel>();
ServiceContainer.Register<ExpenseViewModel>();
}
public SQLiteConnection GetConnection(string path)
{
var fullPath = GetFullDatabasePath (path);
var platform = new SQLitePlatformIOS ();
var connectionWithLock = new SQLiteConnectionWithLock (platform, new SQLiteConnectionString (fullPath, true));
return connectionWithLock;
}
public SQLiteConnection GetConnection()
{
const string sqliteFilename = "sqlite.db"; //データベース名
var documentsPath = Environment.GetFolderPath(Environment.SpecialFolder.Personal); //Documentsフォルダ
var libraryPath = Path.Combine(documentsPath, "..", "Library"); // ライブラリフォルダ
var path = Path.Combine(libraryPath, sqliteFilename);//DBファイルのパス
var plat = new SQLitePlatformIOS();
var conn = new SQLiteConnection(plat, path);
return conn;
}
public SQLite.Net.SQLiteConnection GetConnection(string pathN)
{
var fileName = "RandomThought.db3";
var documentsPath = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
var libraryPath = Path.Combine(documentsPath, "..", "Library");
var path = Path.Combine(pathN, fileName);
var platform = new SQLite.Net.Platform.XamarinIOS.SQLitePlatformIOS();
var connection = new SQLite.Net.SQLiteConnection(platform, path);
return(connection);
}
public SQLiteConnection GetConnection()
{
var sqliteFilename = "ChecklistDatabase.db3";
string documentsPath = Environment.GetFolderPath(Environment.SpecialFolder.Personal); // Documents folder
string libraryPath = new FileManage().GetLibraryFolder(); //Library folder.
var path = Path.Combine(libraryPath, sqliteFilename);
// Create the connection
var plat = new SQLite.Net.Platform.XamarinIOS.SQLitePlatformIOS();
var conn = new SQLite.Net.SQLiteConnection(plat, path);
// Return the database connection
return(conn);
}
public SQLiteConnection GetConnection()
{
var sqliteFilename = "IncidentsSQLite.db3";
string documentsPath = Environment.GetFolderPath (Environment.SpecialFolder.Personal); // Documents folder
string libraryPath = Path.Combine (documentsPath, "..", "Library"); // Library folder
var path = Path.Combine (libraryPath, sqliteFilename);
var platform = new SQLitePlatformIOS ();
var sqLiteConnectionString = new SQLiteConnectionString(path, false);
var conn = new SQLiteConnectionWithLock (platform, sqLiteConnectionString);
return conn;
}
public SQLite.Net.SQLiteConnection GetConnection()
{
var sqliteFilename = "TodoSQLite.db3";
string documentsPath = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
// Documents folder
string libraryPath = Path.Combine(documentsPath, "..", "Library");
// Library folder
var path = Path.Combine(libraryPath, sqliteFilename);
// Create the connection
var plat = new SQLite.Net.Platform.XamarinIOS.SQLitePlatformIOS();
var conn = new SQLite.Net.SQLiteConnection(plat, path);
// Return the database connection
return conn;
}
public SQLiteConnection GetConnection()
{
var arquivo = "LojaMobile.db3";
var caminhoDocumento = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
var caminhoBiblioteca = Path.Combine(caminhoDocumento, "..", "Library");
var caminho = Path.Combine(caminhoBiblioteca, arquivo);
var plataforma = new SQLite.Net.Platform.XamarinIOS.SQLitePlatformIOS();
var conexao = new SQLite.Net.SQLiteConnection(plataforma, caminho);
return(conexao);
}
public SQLiteAsyncConnection GetConnection()
{
const string sqliteFilename = "Conferences.db3";
var documentsPath = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
var libraryPath = Path.Combine(documentsPath, "..", "Library");
var path = Path.Combine(libraryPath, sqliteFilename);
var platform = new SQLitePlatformIOS();
var connectionWithLock = new SQLiteConnectionWithLock(
platform,
new SQLiteConnectionString(path, true));
var connection = new SQLiteAsyncConnection(() => connectionWithLock);
return connection;
}
public SQLiteConnection GetConnection ()
{
var sqliteFilename = "DataBaseDietando.db3";
string documentsPath = Environment.GetFolderPath (Environment.SpecialFolder.Personal); // Documents folder
string libraryPath = Path.Combine (documentsPath, "..", "Library"); // Library folder
var path = Path.Combine (libraryPath, sqliteFilename);
// This is where we copy in the prepopulated database
Console.WriteLine (path);
if (!File.Exists (path)) {
File.Copy (sqliteFilename, path);
}
var plataform = new SQLitePlatformIOS();
var conn = new SQLiteConnection (plataform, path);
// Return the database connection
return conn;
}
public SQLiteConnection GetConnection()
{
var fileName = "contactDB.db3"; //Actual FileName "contactDatabase.db3";
var documentsPath = Environment.GetFolderPath(Environment.SpecialFolder.Personal);
var libraryPath = Path.Combine(documentsPath, "..", "Library");
var path = Path.Combine(libraryPath, fileName);
////New
//if (!File.Exists(path))
//{
// File.Copy(fileName, path);
//}
var platform = new SQLitePlatformIOS();
var connection = new SQLiteConnection(platform, path);
return connection;
}