public override global::System.Data.DataTable Clone() { TestDataTable cln = ((TestDataTable)(base.Clone())); cln.InitVars(); return(cln); }
public void Fill(TestDataTable dt) { var cmd = connection.CreateCommand(); cmd.CommandText = SQL; using (var reader = cmd.ExecuteReader()) dt.Load(reader); }
private void InitClass() { this.DataSetName = "Test"; this.Prefix = ""; this.Namespace = "http://tempuri.org/Test.xsd"; this.EnforceConstraints = true; this.SchemaSerializationMode = global::System.Data.SchemaSerializationMode.IncludeSchema; this.tableTest = new TestDataTable(); base.Tables.Add(this.tableTest); }
internal void InitVars(bool initTable) { this.tableTest = ((TestDataTable)(base.Tables["Test"])); if ((initTable == true)) { if ((this.tableTest != null)) { this.tableTest.InitVars(); } } }
public void ReturnColumnCollectionTest() { MainWindow mainWindow = new MainWindow(); TestDataTable testDataTable = new TestDataTable(); DataTable dataTable = testDataTable.ReturnTestDataTable(); mainWindow.ReturnColumnCollection <int>(dataTable, ""); Assert.Fail(); }
public void TestNullIn() { // arrange // act var values = StartTest() .Where(x => x.Byte_N.In(new byte?[] { null })) .ToArray(Executor); // assert Assert.AreEqual(1, values.Length); TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[0]); }
public void TestDivide() { // arrange // act var values = StartTest() .Where(x => x.PrimaryKey / 2 == TestDataTables.DataTypeTestNulled.PrimaryKey / 2) .ToList(Executor); // assert Assert.AreEqual(1, values.Count); TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[0]); }
public void TestAndCondition() { // arrange // act var values = StartTest() .Where(x => x.PrimaryKey == TestDataTables.DataTypeTestNotNulled.PrimaryKey && x.DateTime == TestDataTables.DataTypeTestNotNulled.DateTime) .ToIEnumerable(Executor) .ToList(); // assert Assert.AreEqual(1, values.Count); TestDataTable.Compare(TestDataTables.DataTypeTestNotNulled, values[0]); }
public void TestNonEquality() { // arrange // act var values = StartTest() .Where(x => x.PrimaryKey != TestDataTables.DataTypeTestNotNulled.PrimaryKey) .ToIEnumerable(Executor) .ToList(); // assert Assert.AreEqual(1, values.Count); TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[0]); }
public void TestEqualityForNullable() { // arrange // act var values = StartTest() .Where(x => x.Float_N == null) .ToIEnumerable(Executor) .ToList(); // assert Assert.AreEqual(1, values.Count); TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[0]); }
public void TestValues() { // arrange // act var values = StartTest() .ToIEnumerable(Executor) .ToList(); // assert Assert.AreEqual(2, values.Count); TestDataTable.Compare(TestDataTables.DataTypeTestNotNulled, values[0]); TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[1]); }
public void TestOrderByDesc() { // arrange // act var values = StartTest() .OrderByDesc(x => x.PrimaryKey) .ToList(Executor); // assert Assert.AreEqual(2, values.Count); TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[0]); TestDataTable.Compare(TestDataTables.DataTypeTestNotNulled, values[1]); }
public void TestIn() { // arrange // act var values = StartTest() .Where(x => x.PrimaryKey.In(new int[1] { TestDataTables.DataTypeTestNulled.PrimaryKey })) .ToArray(Executor); // assert Assert.AreEqual(1, values.Length); TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[0]); }
public void TestGreaterThan() { // arrange var pk = TestDataTables.DataTypeTestNulled.PrimaryKey - 1; // act var values = StartTest() .Where(x => x.PrimaryKey > pk) .ToIEnumerable(Executor) .ToList(); // assert Assert.AreEqual(1, values.Count); TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[0]); }
public void TestJoins() { // arrange // act var values = Query <One2One>() .From(x => x.T1) .InnerJoinOne(x => x.T2).On((q, t2) => q.T1.PrimaryKey == t2.PrimaryKey) .ToIEnumerable(Executor) .ToList(); // assert Assert.AreEqual(2, values.Count); TestDataTable.Compare(TestDataTables.DataTypeTestNotNulled, values[0].T1); TestDataTable.Compare(TestDataTables.DataTypeTestNotNulled, values[0].T2); TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[1].T1); TestDataTable.Compare(TestDataTables.DataTypeTestNulled, values[1].T2); }
public void TableAddGetTest() { var table = new TestDataTable(); for (var i = 0; i < 10; i++) { table.Add(new TestDataItem() { Name = "名字" + i, Age = i }); } var result = table.Get(item => item.Age < 5); Assert.AreEqual(5, result.Count()); }
public void TableQuerySpeedTest() { var table = new TestDataTable(); // 生成 300 个数据项 for (var i = 0; i < 300; i++) { table.Add(new TestDataItem { Name = string.Format("名字:{0}", i), Age = i }); } var stopWatch = new Stopwatch(); stopWatch.Start(); // 查询 10000 次 for (var i = 0; i < 10000; i++) { foreach (var testDataItem in table.Get(item => item.Age == 150 && item.Name == "名字:150")) { } } var oldTime = stopWatch.ElapsedMilliseconds; UnityEngine.Debug.Log(oldTime); // 追加代码 stopWatch.Reset(); stopWatch.Start(); // 查询 10000 次 for (var i = 0; i < 10000; i++) { foreach (var testDataItem in table.AgeIndex.Get(150).Where(item => item.Name == "名字:150")) { } } var newTime = stopWatch.ElapsedMilliseconds; UnityEngine.Debug.Log(newTime); // ? }
internal TestRow(global::System.Data.DataRowBuilder rb) : base(rb) { this.tableTest = ((TestDataTable)(this.Table)); }