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); }