public async Task Core_Data_StoredProcedure_Update() { var testItem = new CustomerInfo(); var reader = new EntityReader <CustomerInfo>(new ConnectionStringFactory().GetDefaultConnection()); var customerTests = new CustomerInfoTests(); await customerTests.Core_Entity_CustomerInfo_Insert(); testItem = reader.GetByKey(CustomerTests.RecycleBin.LastOrDefault()); var updateProc = new StoredProcedure <CustomerInfo>() { StoredProcedureName = "CustomerInfoUpdate", Parameters = new List <SqlParameter>() { new SqlParameter("@Key", testItem.Key), new SqlParameter("@FirstName", testItem.FirstName), new SqlParameter("@MiddleName", testItem.MiddleName), new SqlParameter("@LastName", testItem.LastName), new SqlParameter("@BirthDate", testItem.BirthDate), new SqlParameter("@GenderId", testItem.GenderId), new SqlParameter("@CustomerTypeId", testItem.CustomerTypeId) } }; Assert.IsTrue(updateProc.StoredProcedureName.Length > 0); Assert.IsTrue(updateProc.Parameters.Count() > 0); }
public async Task Core_Data_StoredProcedure_Delete() { var testItem = new CustomerInfo(); var reader = new EntityReader <CustomerInfo>(new ConnectionStringFactory().GetDefaultConnection()); var customerTests = new CustomerInfoTests(); await customerTests.Core_Entity_CustomerInfo_Insert(); testItem = reader.GetByKey(CustomerTests.RecycleBin.LastOrDefault()); var deleteProc = new StoredProcedure <CustomerInfo>() { StoredProcedureName = "CustomerInfoDelete", Parameters = new List <SqlParameter>() { new SqlParameter("@Key", testItem.Key) } }; Assert.IsTrue(deleteProc.StoredProcedureName.Length > 0); Assert.IsTrue(deleteProc.Parameters.Count() > 0); }
public static async Task ClassInit(TestContext context) { // Database is required for these tests var databaseAccess = false; using (var connection = new SqlConnection(new ConnectionStringFactory().GetDefaultConnection())) { databaseAccess = connection.CanOpen(); } Assert.IsTrue(databaseAccess, @"App_Data\\ConnectionStrings.config DefaultConnection is not able to connect to SQL Server. Please check your connection string and try again."); // Need a few records to test with across all functions var customerTests = new CustomerInfoTests(); await customerTests.Core_Entity_CustomerInfo_Insert(); await customerTests.Core_Entity_CustomerInfo_Insert(); await customerTests.Core_Entity_CustomerInfo_Insert(); await customerTests.Core_Entity_CustomerInfo_Insert(); await customerTests.Core_Entity_CustomerInfo_Insert(); }
public static async Task Cleanup() { await CustomerInfoTests.Cleanup(); }