private void CreateLocalDb()
{
_path = Path.Combine(Environment.GetFolderPath(Environment.SpecialFolder.ApplicationData), "festi.sqlite");
if (File.Exists(_path))
{
File.Delete(_path);
}
SQLiteConnection.CreateFile(_path);
}
static SQLiteTestSuite()
{
if (File.Exists(FileName))
{
File.Delete(FileName);
}
SqliteConnection.CreateFile(FileName);
using (var connection = new SqliteConnection(ConnectionString))
{
connection.Open();
connection.Execute(@"CREATE TABLE Stuff (TheId integer primary key autoincrement not null, Name nvarchar(100) not null, Created DateTime null) ");
connection.Execute(@"CREATE TABLE People (Id integer primary key autoincrement not null, Name nvarchar(100) not null) ");
connection.Execute(@"CREATE TABLE Users (Id integer primary key autoincrement not null, Name nvarchar(100) not null, Age int not null) ");
connection.Execute(@"CREATE TABLE Automobiles (Id integer primary key autoincrement not null, Name nvarchar(100) not null) ");
connection.Execute(@"CREATE TABLE Results (Id integer primary key autoincrement not null, Name nvarchar(100) not null, [Order] int not null) ");
connection.Execute(@"CREATE TABLE ObjectX (ObjectXId nvarchar(100) not null, Name nvarchar(100) not null) ");
connection.Execute(@"CREATE TABLE ObjectY (ObjectYId integer not null, Name nvarchar(100) not null) ");
}
}
public static void CreateDatabase(string dbName)
{
SQLiteConnection.CreateFile(dbName);
}
/// <summary>
/// Create a new SQLite database.
/// </summary>
/// <param name="location">File location to create database</param>
public static void CreateDatabase(string location)
{
SQLiteDataConnection.CreateFile(location);
}
