public void Test_DqlFill_Schema() { string select = "Select * from dm_cabinet enable(return_top 1)"; string cnstr = "User=dmadmin;Password=@vmware99;Repository=ls_repos"; DataSet dataset = new DataSet(); using (var cn = new DqlConnection(cnstr)) { cn.Open(); using (var cmd = new DqlCommand(select, cn)) { using (var adapter = new DqlDataAdapter(cmd)) { adapter.FillSchema(dataset); } } } }
/// <summary> /// Executes the query. /// </summary> /// <param name="select">The select.</param> /// <returns>DataSet.</returns> public override DataSet ExecuteQuery(string select) { DataSet dataSet = null; using (var cn = new DqlConnection(ConnectionString)) { cn.Open(); using (DqlCommand cmd = new DqlCommand(select, cn)) { using (DqlDataAdapter adapter = new DqlDataAdapter(cmd)) { dataSet = new DataSet(); adapter.Fill(dataSet); } } } return(dataSet); }
public void Test_DqlFill_RepeatingValues() { string select = "select r_object_id, object_name, keywords, authors from dm_cabinet where not object_name like 'dm%' and object_name = 'ls_repos'"; DataSet dataset = new DataSet(); string cnstr = "User=dmadmin;Password=@vmware99;Repository=ls_repos"; using (DqlConnection cn = new DqlConnection(cnstr)) { cn.Open(); using (DqlCommand cmd = new DqlCommand(select, cn)) { using (DqlDataAdapter adapter = new DqlDataAdapter(cmd)) { var schemas = adapter.FillSchema(dataset, SchemaType.Source); Assert.AreEqual(dataset.Tables[0].Rows[0]["keywords"].ToString(), "test2|test3|test1"); Assert.AreEqual(dataset.Tables[0].Rows[0]["authors"].ToString(), "author2|author3|author1"); } } } }
public void Test_DqlFill() { string select = "Select r_object_id, keywords from dm_cabinet enable(return_top 1); select * from dm_document enable(return_top 1)"; DataSet dataset = new DataSet(); string cnstr = "User=dmadmin;Password=@vmware99;Repository=ls_repos"; using (DqlConnection cn = new DqlConnection(cnstr)) { cn.Open(); using (DqlCommand cmd = new DqlCommand(select, cn)) { using (DqlDataAdapter adapter = new DqlDataAdapter(cmd)) { var schemas = adapter.Fill(dataset); Assert.AreEqual(dataset.Tables.Count, 2); Assert.AreEqual(dataset.Tables[0].Rows.Count, 1); Assert.AreEqual(dataset.Tables[1].Rows.Count, 1); } } } }
public void Test_DqlMultiQuery() { DataSet dataset = new DataSet("MulitQueryTest"); string cnstr = "User=dmadmin;Password=@vmware99;Repository=ls_repos"; using (DqlConnection cn = new DqlConnection(cnstr)) { cn.Open(); using (DqlCommand cmd = new DqlCommand(File.ReadAllText(".\\DqlMultiQueryTest.txt"), cn)) { using (DqlDataAdapter adapter = new DqlDataAdapter(cmd)) { var schemas = adapter.Fill(dataset); var table = dataset.MergeAll(); Assert.AreEqual(dataset.Tables.Count, 21); Assert.AreEqual(table.Rows.Count, 10000); //Assert.AreEqual(dataset.Tables[0].Rows.Count, 1); //Assert.AreEqual(dataset.Tables[1].Rows.Count, 1); } } } }
/// <summary> /// Executes the query. /// </summary> /// <param name="select">The select.</param> /// <param name="token">The token.</param> /// <returns>DataSet.</returns> public override DataSet ExecuteQuery(string select, CancellationToken token) { if (UseExternalQueryEngine()) { return(ExecuteQueryExternal(select)); } DataSet dataSet = null; using (var cn = new DqlConnection(ConnectionString)) { cn.Open(); using (DqlCommand cmd = new DqlCommand(select, cn)) { using (DqlDataAdapter adapter = new DqlDataAdapter(cmd)) { dataSet = new DataSet(); adapter.Fill(dataSet, token); } } } return(dataSet); }