private LinqToDBDomainContext CreateDomainContext(StorageMappingDescriptor storageMappingDescriptor)
{
var linqToDbModel = _linqToDbModelFactory.Create(storageMappingDescriptor.EntityContainerName);
var connections = Connections.GetOrAdd(
storageMappingDescriptor.ConnectionStringIdentity,
connectionStringIdentity =>
{
var dataProvider = new SQLiteDataProvider();
var connectionString = _connectionStringSettings.GetConnectionString(connectionStringIdentity);
var connection = (SQLiteConnection)dataProvider.CreateConnection(connectionString);
connection.Open();
var dataConnection = new DataConnection(dataProvider, connection)
{
CommandTimeout = linqToDbModel.QueryExecutionTimeout,
IsMarsEnabled = false
};
dataConnection.AddMappingSchema(linqToDbModel.MappingSchema);
return(Tuple.Create(connection, TuneConnection(dataConnection)));
});
return(new LinqToDBDomainContext(connections.Item1,
connections.Item2,
new ManagedConnectionStateScopeFactory(),
new WritingStrategyFactory(),
linqToDbModel.TransactionOptions,
new NullPendingChangesHandlingStrategy()));
}
public void TestSqlLiteMS()
{
var provider = new SQLiteDataProvider(ProviderName.SQLiteMS);
try
{
using (var db = new DataConnection(provider, "Data Source=" + MainActivity.SQLiteDbPath))
{
db.CreateTable <Test>();
db.Insert(new Test()
{
Field = 5
});
var results = db.GetTable <Test>().ToArray();
Assert.AreEqual(1, results.Length);
Assert.AreEqual(5, results[0].Field);
}
}
finally
{
SQLiteTools.DropDatabase("test_db");
}
}
public static void Initialize()
{
var dataProvider = new SQLiteDataProvider();
var entryProvider = new EntryProvider(dataProvider);
var settingsProvider = new SettingsProvider(dataProvider);
ProC.Register <IEntryProvider>(entryProvider);
ProC.Register <ISettingsProvider>(settingsProvider);
}
public void DatabaseCacheTest_2()
{
DatabaseCacheTest();
var provider = new SQLiteDataProvider(@"..\..\..\test_database\resources\covid.db");
var cacheSystem = new DatabaseCache();
cacheSystem.Attach(provider);
cacheSystem.CheckUpdate(); //check if the data is fresh (yesterday is present in the db) and update the db if not
}
public void DataProviderTest()
{
var provider = new SQLiteDataProvider(@"..\..\resources\covid.db");
try
{
provider.ClearDayInfoData();
}
catch (Exception)
{
// ignored
}
//Test insertion of CountryInfo list
IDataProvider <CountryInfo> mockDataProvider = new MockDataProvider();
var list = mockDataProvider.GetCountryData();
provider.InsertCountryData(list);
//Extract list of countryInfoEx
var countryInfoExList = provider.GetCountryData();
foreach (var countryInfo in countryInfoExList)
{
var tuple = (countryInfo.Confirmed, countryInfo.Deaths, countryInfo.Recovered, countryInfo.Continent,
countryInfo.Population);
switch (countryInfo.Name)
{
case "Italy":
Assert.AreEqual(tuple, (2, 0, 1, "Europe", 50_000_000));
break;
case "USA":
Assert.AreEqual(tuple, (18, 4, 0, "America", 300_000_000));
break;
case "Romania":
Assert.AreEqual(tuple, (25, 3, 1, "Europe", 19_000_000));
break;
case "China":
Assert.AreEqual(tuple, (80, 10, 5, "Asia", 1_000_000_000));
break;
}
}
//Test extraction the most recent date
Assert.AreEqual(new Date(1983, 11, 30), provider.GetTheMostRecentDateOfData());
}
static void Main()
{
Application.EnableVisualStyles();
Application.SetCompatibleTextRenderingDefault(false);
var provider = new SQLiteDataProvider();
var cacheSystem = new DatabaseCache();
cacheSystem.Attach(provider);
cacheSystem.CheckUpdate(); //check if the data is fresh (yesterday is present in the db)
var data = provider.GetCountryData();
MapView mapView = new MapView(data);
IView globalView = new GlobalView(data);
CountryView countryView = new CountryView(data);
mapView.Subscribe(countryView);
Application.Run(new MainForm(new List <IView> {
mapView, globalView, countryView
}));
}
public static void Main()
{
var dataProvider = new SQLiteDataProvider();
var connection = dataProvider.CreateConnection(ConnectionString);
connection.Open();
var dataConnection = new DataConnection(dataProvider, connection);
dataConnection.MappingSchema.SetDataType(typeof(TimeSpan), DataType.Int64);
dataConnection.CreateTable <Category>();
dataConnection.GetTable <Category>()
.DataContextInfo
.DataContext
.Insert(new Category
{
Id = 2,
Time = new TimeSpan(10, 0, 0)
});
foreach (var category in dataConnection.GetTable <Category>())
{
Console.WriteLine($@"Id: {category.Id}, Time: {category.Time}");
}
}
public EnglishWordDb(SQLiteDataProvider dataProvider, string connectionString)
: base(dataProvider, connectionString)
{
InitDataContext();
}
/// <summary>
/// Get connection string for VC Code Symbol table
/// </summary>
/// <param name="vcCodeFolderPath">Folder of VC Code C/C++ Source Code</param>
/// <param name="provider"></param>
/// <param name="withErrorMessage"></param>
/// <returns>"" = No connection found</returns>
public static string GetConnectionString(string vcCodeFolderPath, out IDataProvider provider, bool withErrorMessage = true)
{
provider = new SQLiteDataProvider("SQLite.Classic");
return(VcDbUtilities.GetConnectionString(vcCodeFolderPath, withErrorMessage));
}
/// <summary>
/// Get connection string and data provider for SQLite database from path
/// </summary>
/// <param name="sqliteDbPath"></param>
/// <param name="provider"></param>
/// <returns></returns>
/// string dsnName = "DSN=MySqlEa;Trusted_Connection=Yes;";
// dsnName = "DSN=MySqlEa;";
public static string GetConnectionString(string sqliteDbPath, out IDataProvider provider)
{
provider = new SQLiteDataProvider();
return($"Data Source={sqliteDbPath};");
}
