public void Test_AccessSchema()
{
AccessDbConnectionStringBuilder builder = new AccessDbConnectionStringBuilder(@".\Northwinds.accdb");
OleDbDataSource dql = new OleDbDataSource(builder.ConnectionString);
var model = dql.GetSchemaModel("Customers");
Assert.AreEqual(model.TableName, "Customers");
}
public void Test_Accesschemas()
{
AccessDbConnectionStringBuilder builder = new AccessDbConnectionStringBuilder(@".\Northwinds.accdb");
OleDbDataSource dql = new OleDbDataSource(builder.ConnectionString);
var model = dql.GetSchemaModel();
Assert.AreEqual(1, model.Where(w => w.TableName == "Customers").Count());
}
/// <summary>
/// Tests the access.
/// </summary>
private void TestAccess()
{
AccessDbConnectionStringBuilder builder = new AccessDbConnectionStringBuilder(btnDataSource.Text);
//builder["Extended Properties"] = txtExt.Text;
using (OleDbConnection cn = new OleDbConnection(builder.ConnectionString))
{
cn.Open();
}
}
/// <summary>
/// Creates the access.
/// </summary>
private void CreateAccess()
{
AccessDbConnectionStringBuilder builder = new AccessDbConnectionStringBuilder(btnDataSource.Text)
{
["User ID"] = txtUserId.Text,
["Password"] = txtPassword.Text
};
Model.DataSource = new AccessDataSource(builder.ConnectionString);
Model.RefreshSchemaModel();
Model.DataSource.ProviderName = "Microsoft Access";
}
public void Test_KeyTypes()
{
AccessDbConnectionStringBuilder builder = new AccessDbConnectionStringBuilder(@".\Northwinds.accdb");
OleDbDataSource dql = new OleDbDataSource(builder.ConnectionString);
var strings = new string[] { "1", "2" };
var ints = Array.ConvertAll(strings, int.Parse);
QueryBuilder query = dql.GetQueryBuilder();
var select = query.BuildSql("ID", new string[] { "City", "Company" }, "Customers", "left", "0", "ID", ints, null);
var table = dql.ExecuteQuery(select);
}
public void Test_AccessQueryBuilder()
{
AccessDbConnectionStringBuilder builder = new AccessDbConnectionStringBuilder(@".\Northwinds.accdb");
OleDbDataSource dql = new OleDbDataSource(builder.ConnectionString);
QueryBuilder query = dql.GetQueryBuilder();
var select = query.BuildSql("ID", new string[] { "City", "Company" }, "Customers", "left", "0", "ID", new int[] { 1, 2 }, null);
var table = dql.ExecuteQuery(select);
Assert.AreEqual(table.Tables.Count, 1);
Assert.AreEqual(table.Tables[0].Rows.Count, 2);
}
