public void SingleObjectHurlTest() { SqlDataRequest dataRequest = new SqlDataRequest(ConnectionString); var obj = new { Id = Guid.NewGuid(), Name = string.Format("Test :{0}", DateTime.Now.ToLongDateString()), Description = string.Format("Description :{0}", DateTime.Now.ToLongDateString()), Details = string.Format("Details :{0}", DateTime.Now.ToLongDateString()), RecordedDate = DateTime.Now, IsActive = true }; int rowsAffected = dataRequest.Hurl("[dbo].[usp_Test_Insert]", obj); Assert.IsTrue(rowsAffected > 0); }
public void MultiObjectHurlTest() { SqlDataRequest dataRequest = new SqlDataRequest(ConnectionString); var objForList1 = new { Id = Guid.NewGuid(), Name = string.Format("Test :{0}", DateTime.Now.ToLongDateString()), Description = string.Format("Description :{0}", DateTime.Now.ToLongDateString()), Details = string.Format("Details :{0}", DateTime.Now.ToLongDateString()), RecordedDate = DateTime.Now, IsActive = true }; var objForList2 = new { Id = Guid.NewGuid(), Name = string.Format("Test :{0}", DateTime.Now.ToLongDateString()), Description = string.Format("Description :{0}", DateTime.Now.ToLongDateString()), Details = string.Format("Details :{0}", DateTime.Now.ToLongDateString()), RecordedDate = DateTime.Now, IsActive = true }; var objForList3 = new { Id = Guid.NewGuid(), Name = string.Format("Test :{0}", DateTime.Now.ToLongDateString()), Description = string.Format("Description :{0}", DateTime.Now.ToLongDateString()), Details = string.Format("Details :{0}", DateTime.Now.ToLongDateString()), RecordedDate = DateTime.Now, IsActive = true }; List<dynamic> objects = new List<dynamic>() { objForList1, objForList2, objForList3 }; int rowsAffected3 = dataRequest.Hurl("[dbo].[usp_Test_Insert]", objects); Assert.IsTrue(rowsAffected3 > 0); }