// Obsolete as of 2007.1.1021.0 //protected override void CreateExtendedProperties(esColumnMetadataCollection extendedProps) //{ // if (null == extendedProps["NewId"]) // { // esColumnMetadata col = new esColumnMetadata("NewId", this.Meta.Columns.Count + 1, Type.GetType("System.Int32")); // col.PropertyName = "NewId"; // extendedProps.Add(col); // } // if (null == extendedProps["OrderIndex"]) // { // esColumnMetadata col = new esColumnMetadata("OrderIndex", this.Meta.Columns.Count + 1, Type.GetType("System.Int32")); // col.PropertyName = "OrderIndex"; // extendedProps.Add(col); // } //} //public void AddOrderIndexColumn() //{ // if (this.Table != null && this.Table.Columns.Contains("OrderIndex") == false) // { // this.Table.Columns.Add("OrderIndex", typeof(Int16)); // } //} //public DataTable GetTable() //{ // return this.Table; //} public static void CustomForEach() { AggregateTestCollection coll = new AggregateTestCollection(); coll.LoadAll(); foreach (AggregateTest entity in coll) { entity.LastName = "CustomForEach"; } }
public void EmptyQueryReturnsSelectAll() { aggTestColl = new AggregateTestCollection(); Assert.IsTrue(aggTestColl.LoadAll()); Assert.AreEqual(30, aggTestColl.Count, "LoadAll"); aggTestColl = new AggregateTestCollection(); Assert.IsTrue(aggTestColl.Query.Load()); Assert.AreEqual(30, aggTestColl.Count, "Query.Load"); aggTestColl = new AggregateTestCollection(); aggTestColl.Query.LoadDataTable(); Assert.AreEqual(0, aggTestColl.Count, "Query.LoadDataTable"); }
public void TestIdentityInsert() { AggregateTestCollection coll = new AggregateTestCollection(); coll.LoadAll(); StringBuilder sql = new StringBuilder(); sql.AppendLine("SET IDENTITY_INSERT [AggregateTest] ON"); sql.AppendLine("SET NOCOUNT ON"); for (int i = 1; i < coll.Count; i++) { sql.AppendLine("INSERT INTO [AggregateTest]([ID], [LastName])"); sql.AppendLine("VALUES(" + i.ToString() + ", '" + coll[i].LastName + "')"); } sql.AppendLine("SET IDENTITY_INSERT [AggregateTest] OFF"); //esUtility u = new esUtility(); //u.ExecuteNonQuery(esQueryType.Text, sql.ToString()); }
public void TestIdentityInsert() { AggregateTestCollection coll = new AggregateTestCollection(); coll.LoadAll(); StringBuilder sql = new StringBuilder(); sql.AppendLine("SET IDENTITY_INSERT [AggregateTest] ON"); sql.AppendLine("SET NOCOUNT ON"); for (int i = 1; i < coll.Count; i++) { sql.AppendLine("INSERT INTO [AggregateTest]([ID], [LastName])"); sql.AppendLine("VALUES(" + i.ToString() + ", '" + coll[ i ].LastName + "')"); } sql.AppendLine("SET IDENTITY_INSERT [AggregateTest] OFF"); //esUtility u = new esUtility(); //u.ExecuteNonQuery(esQueryType.Text, sql.ToString()); }
public void TestCommandTimeoutConfig() { switch (aggTestColl.es.Connection.ProviderSignature.DataProviderName) { case "EntitySpaces.SqlClientProvider": // Collection aggTestColl = new AggregateTestCollection(); Assert.AreEqual(39, aggTestColl.es.Connection.CommandTimeout); Assert.IsTrue(aggTestColl.Query.Load(), "Query.Load"); aggTestColl = new AggregateTestCollection(); Assert.AreEqual(39, aggTestColl.es.Connection.CommandTimeout); Assert.IsTrue(aggTestColl.LoadAll(), "LoadAll"); // Entity aggTest = new AggregateTest(); Assert.AreEqual(39, aggTest.es.Connection.CommandTimeout); aggTest.Query.es.Top = 1; Assert.IsTrue(aggTest.Query.Load(), "Query.Load"); int aggKey = aggTest.Id.Value; aggTest = new AggregateTest(); Assert.AreEqual(39, aggTest.es.Connection.CommandTimeout); Assert.IsTrue(aggTest.LoadByPrimaryKey(aggKey), "LoadByPK"); break; default: Assert.Ignore("tested for SQL Server only"); break; } }
public void TestCommandTimeout() { switch (aggTestColl.es.Connection.ProviderSignature.DataProviderName) { case "EntitySpaces.SqlClientProvider": aggTestColl = new AggregateTestCollection(); aggTestColl.es.Connection.CommandTimeout = 49; Assert.IsTrue(aggTestColl.Query.Load(), "Query.Load"); Assert.AreEqual(49, aggTestColl.es.Connection.CommandTimeout); aggTestColl = new AggregateTestCollection(); Assert.IsTrue(aggTestColl.LoadAll(), "LoadAll"); Assert.AreEqual(39, aggTestColl.es.Connection.CommandTimeout); break; default: Assert.Ignore("SQL Server only"); break; } }
public void CollectionLoadAllFalse() { AggregateTestCollection testColl = new AggregateTestCollection(); try { testColl.LoadAll(); testColl.MarkAllAsDeleted(); testColl.Save(); testColl = new AggregateTestCollection(); Assert.IsFalse(testColl.LoadAll()); } finally { UnitTestBase.RefreshDatabase(); } }
public void NoAddNew() { int aggTestId = -1; try { using (esTransactionScope scope = new esTransactionScope()) { aggTest = new AggregateTest(); aggTest.Age = 30; aggTest.Save(); aggTestId = aggTest.Id.Value; aggTest = new AggregateTest(); Assert.IsTrue(aggTest.LoadByPrimaryKey(aggTestId)); Assert.AreEqual(30, aggTest.Age.Value); } } finally { // Clean up aggTest = new AggregateTest(); if (aggTest.LoadByPrimaryKey(aggTestId)) { aggTest.MarkAsDeleted(); aggTest.Save(); } aggTestColl = new AggregateTestCollection(); aggTestColl.LoadAll(); Assert.AreEqual(30, aggTestColl.Count); } }
public void RejectChangesCollection() { using (esTransactionScope scope = new esTransactionScope()) { aggTest = aggTestColl.AddNew(); aggTestColl.Save(); int aggTestId = aggTest.Id.Value; aggTestColl = new AggregateTestCollection(); aggTestColl.LoadAll(); Assert.AreEqual(31, aggTestColl.Count); aggTest = aggTestColl.FindByPrimaryKey(aggTestId); aggTest.MarkAsDeleted(); aggTestColl.AddNew(); aggTestColl.RejectChanges(); aggTestColl.Save(); aggTestColl = new AggregateTestCollection(); aggTestColl.LoadAll(); Assert.AreEqual(31, aggTestColl.Count); // Cleanup aggTest = new AggregateTest(); Assert.IsTrue(aggTest.LoadByPrimaryKey(aggTestId)); aggTest.MarkAsDeleted(); aggTest.Save(); } }
public void UpdateOrInsertEntityCustom() { using (esTransactionScope scope = new esTransactionScope()) { // The PK does not exist, so insert AggregateTest entity = new AggregateTest(); entity.SaveUpdateOrInsert(-1, "IsInsert"); int aggTestId = entity.Id.Value; entity = new AggregateTest(); Assert.IsTrue(entity.LoadByPrimaryKey(aggTestId)); Assert.AreEqual("IsInsert", entity.LastName); // The PK does exist, so update entity = new AggregateTest(); entity.SaveUpdateOrInsert(aggTestId, "IsUpdate"); entity = new AggregateTest(); Assert.IsTrue(entity.LoadByPrimaryKey(aggTestId)); Assert.AreEqual("IsUpdate", entity.LastName); // Clean up entity.MarkAsDeleted(); entity.Save(); aggTestColl = new AggregateTestCollection(); aggTestColl.LoadAll(); Assert.AreEqual(30, aggTestColl.Count); } }
public void UpdateOrInsertEntity() { using (esTransactionScope scope = new esTransactionScope()) { // The PK does not exist, so insert aggTest = new AggregateTest(); Assert.IsFalse(aggTest.LoadByPrimaryKey(0)); aggTest.LastName = "IsInsert"; aggTest.Save(); int aggTestId = aggTest.Id.Value; // The PK does exist, so update aggTest = new AggregateTest(); Assert.IsTrue(aggTest.LoadByPrimaryKey(aggTestId)); Assert.AreEqual("IsInsert", aggTest.LastName); aggTest.LastName = "IsUpdate"; aggTest.Save(); aggTest = new AggregateTest(); Assert.IsTrue(aggTest.LoadByPrimaryKey(aggTestId)); Assert.AreEqual("IsUpdate", aggTest.LastName); // Clean up aggTest.MarkAsDeleted(); aggTest.Save(); aggTestColl = new AggregateTestCollection(); aggTestColl.LoadAll(); Assert.AreEqual(30, aggTestColl.Count); } }
public void RetrieveAutoIncrementingKey() { using (esTransactionScope scope = new esTransactionScope()) { aggTest = aggTestColl.AddNew(); aggTestColl.Save(); int aggTestId = aggTest.Id.Value; aggTestColl = new AggregateTestCollection(); aggTestColl.LoadAll(); Assert.AreEqual(31, aggTestColl.Count); aggTest = new AggregateTest(); Assert.IsTrue(aggTest.LoadByPrimaryKey(aggTestId)); aggTest.MarkAsDeleted(); aggTest.Save(); aggTestColl = new AggregateTestCollection(); aggTestColl.LoadAll(); Assert.AreEqual(30, aggTestColl.Count); } }
public void EmptyCollection() { using (esTransactionScope scope = new esTransactionScope()) { aggTestColl = new AggregateTestCollection(); aggTestColl.Save(); aggTestColl = new AggregateTestCollection(); aggTestColl.LoadAll(); Assert.AreEqual(30, aggTestColl.Count); } }
public void EmptyEntity() { using (esTransactionScope scope = new esTransactionScope()) { aggTest = new AggregateTest(); aggTest.Save(); int aggTestId = aggTest.Id.Value; aggTest = new AggregateTest(); Assert.IsTrue(aggTest.LoadByPrimaryKey(aggTestId)); // Clean up aggTest.MarkAsDeleted(); aggTest.Save(); aggTestColl = new AggregateTestCollection(); aggTestColl.LoadAll(); Assert.AreEqual(30, aggTestColl.Count); } }
public static void RefreshDatabase(string connectionName) { AggregateTestCollection aggTestColl = new AggregateTestCollection(); if (connectionName.Length != 0) { aggTestColl.es.Connection.Name = connectionName; } aggTestColl.LoadAll(); aggTestColl.MarkAllAsDeleted(); aggTestColl.Save(); aggTestColl = new AggregateTestCollection(); AggregateTest aggTest = new AggregateTest(); if (connectionName.Length != 0) { aggTestColl.es.Connection.Name = connectionName; aggTest.es.Connection.Name = connectionName; } aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "3"; aggTest.str().FirstName = "David"; aggTest.str().LastName = "Doe"; aggTest.str().Age = "16"; aggTest.str().HireDate = "2000-02-16 05:59:31"; aggTest.str().Salary = "34.71"; aggTest.str().IsActive = "true"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "1"; aggTest.str().FirstName = "Sarah"; aggTest.str().LastName = "McDonald"; aggTest.str().Age = "28"; aggTest.str().HireDate = "1999-03-25 00:00:00"; aggTest.str().Salary = "11.06"; aggTest.str().IsActive = "true"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "3"; aggTest.str().FirstName = "David"; aggTest.str().LastName = "Vincent"; aggTest.str().Age = "43"; aggTest.str().HireDate = "2000-10-17 00:00:00"; aggTest.str().Salary = "10.27"; aggTest.str().IsActive = "false"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "2"; aggTest.str().FirstName = "Fred"; aggTest.str().LastName = "Smith"; aggTest.str().Age = "15"; aggTest.str().HireDate = "1999-03-15 00:00:00"; aggTest.str().Salary = "15.15"; aggTest.str().IsActive = "true"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "3"; aggTest.str().FirstName = "Sally"; aggTest.str().LastName = "Johnson"; aggTest.str().Age = "30"; aggTest.str().HireDate = "2000-10-07 00:00:00"; aggTest.str().Salary = "14.36"; aggTest.str().IsActive = "true"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "5"; aggTest.str().FirstName = "Jane"; aggTest.str().LastName = "Rapaport"; aggTest.str().Age = "44"; aggTest.str().HireDate = "2002-05-02 00:00:00"; aggTest.str().Salary = "13.56"; aggTest.str().IsActive = "false"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "4"; aggTest.str().FirstName = "Paul"; aggTest.str().LastName = "Gellar"; aggTest.str().Age = "16"; aggTest.str().HireDate = "2000-09-27 00:00:00"; aggTest.str().Salary = "18.44"; aggTest.str().IsActive = "true"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "2"; aggTest.str().FirstName = "John"; aggTest.str().LastName = "Jones"; aggTest.str().Age = "31"; aggTest.str().HireDate = "2002-04-22 00:00:00"; aggTest.str().Salary = "17.65"; aggTest.str().IsActive = "true"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "3"; aggTest.str().FirstName = "Michelle"; aggTest.str().LastName = "Johnson"; aggTest.str().Age = "45"; aggTest.str().HireDate = "2003-11-14 00:00:00"; aggTest.str().Salary = "16.86"; aggTest.str().IsActive = "false"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "2"; aggTest.str().FirstName = "David"; aggTest.str().LastName = "Costner"; aggTest.str().Age = "17"; aggTest.str().HireDate = "2002-04-11 00:00:00"; aggTest.str().Salary = "21.74"; aggTest.str().IsActive = "true"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "4"; aggTest.str().FirstName = "William"; aggTest.str().LastName = "Gellar"; aggTest.str().Age = "32"; aggTest.str().HireDate = "2003-11-04 00:00:00"; aggTest.str().Salary = "20.94"; aggTest.str().IsActive = "false"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "3"; aggTest.str().FirstName = "Sally"; aggTest.str().LastName = "Rapaport"; aggTest.str().Age = "39"; aggTest.str().HireDate = "2002-04-01 00:00:00"; aggTest.str().Salary = "25.82"; aggTest.str().IsActive = "true"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "5"; aggTest.str().FirstName = "Jane"; aggTest.str().LastName = "Vincent"; aggTest.str().Age = "18"; aggTest.str().HireDate = "2003-10-25 00:00:00"; aggTest.str().Salary = "25.03"; aggTest.str().IsActive = "true"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "2"; aggTest.str().FirstName = "Fred"; aggTest.str().LastName = "Costner"; aggTest.str().Age = "33"; aggTest.str().HireDate = "1998-05-20 00:00:00"; aggTest.str().Salary = "24.24"; aggTest.str().IsActive = "false"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "1"; aggTest.str().FirstName = "John"; aggTest.str().LastName = "Johnson"; aggTest.str().Age = "40"; aggTest.str().HireDate = "2003-10-15 00:00:00"; aggTest.str().Salary = "29.12"; aggTest.str().IsActive = "true"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "3"; aggTest.str().FirstName = "Michelle"; aggTest.str().LastName = "Rapaport"; aggTest.str().Age = "19"; aggTest.str().HireDate = "1998-05-10 00:00:00"; aggTest.str().Salary = "28.32"; aggTest.str().IsActive = "true"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "4"; aggTest.str().FirstName = "Sarah"; aggTest.str().LastName = "Doe"; aggTest.str().Age = "34"; aggTest.str().HireDate = "1999-12-03 00:00:00"; aggTest.str().Salary = "27.53"; aggTest.str().IsActive = "false"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "4"; aggTest.str().FirstName = "William"; aggTest.str().LastName = "Jones"; aggTest.str().Age = "41"; aggTest.str().HireDate = "1998-04-30 00:00:00"; aggTest.str().Salary = "32.41"; aggTest.str().IsActive = "true"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "1"; aggTest.str().FirstName = "Sarah"; aggTest.str().LastName = "McDonald"; aggTest.str().Age = "21"; aggTest.str().HireDate = "1999-11-23 00:00:00"; aggTest.str().Salary = "31.62"; aggTest.str().IsActive = "false"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "4"; aggTest.str().FirstName = "Jane"; aggTest.str().LastName = "Costner"; aggTest.str().Age = "28"; aggTest.str().HireDate = "1998-04-20 00:00:00"; aggTest.str().Salary = "36.50"; aggTest.str().IsActive = "true"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "2"; aggTest.str().FirstName = "Fred"; aggTest.str().LastName = "Douglas"; aggTest.str().Age = "42"; aggTest.str().HireDate = "1999-11-13 00:00:00"; aggTest.str().Salary = "35.71"; aggTest.str().IsActive = "true"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "3"; aggTest.str().FirstName = "Sarah"; aggTest.str().LastName = "Jones"; aggTest.str().Age = "22"; aggTest.str().HireDate = "2001-06-07 00:00:00"; aggTest.str().Salary = "34.91"; aggTest.str().IsActive = "false"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "3"; aggTest.str().FirstName = "Michelle"; aggTest.str().LastName = "Doe"; aggTest.str().Age = "29"; aggTest.str().HireDate = "1999-11-03 00:00:00"; aggTest.str().Salary = "39.79"; aggTest.str().IsActive = "true"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "4"; aggTest.str().FirstName = "Paul"; aggTest.str().LastName = "Costner"; aggTest.str().Age = "43"; aggTest.str().HireDate = "2001-05-28 00:00:00"; aggTest.str().Salary = "39.00"; aggTest.str().IsActive = "true"; aggTest = aggTestColl.AddNew(); aggTest.str().DepartmentID = "0"; aggTest.str().FirstName = ""; aggTest.str().LastName = ""; aggTest.str().Age = "0"; aggTest.str().Salary = "0"; aggTest = aggTestColl.AddNew(); aggTest = aggTestColl.AddNew(); aggTest = aggTestColl.AddNew(); aggTest = aggTestColl.AddNew(); aggTest = aggTestColl.AddNew(); aggTestColl.Save(); }
public void FilteredDeleteAll() { using (esTransactionScope scope = new esTransactionScope()) { AggregateTestCollection aggTestColl = new AggregateTestCollection(); aggTestColl.LoadAll(); Assert.AreEqual(30, aggTestColl.Count); aggTestColl.Filter = aggTestColl.AsQueryable().Where(f => f.LastName == "Doe"); Assert.AreEqual(3, aggTestColl.Count); aggTestColl.MarkAllAsDeleted(); aggTestColl.Filter = null; Assert.AreEqual(27, aggTestColl.Count); aggTestColl.Save(); aggTestColl = new AggregateTestCollection(); aggTestColl.LoadAll(); Assert.AreEqual(27, aggTestColl.Count); } }