public void FetchByDynamicObjParamsTest() { SqlDataRequest dataRequest = new SqlDataRequest(ConnectionString); string result = dataRequest.Fetch("[dbo].[usp_Test_Select]", new { Id = new Guid("69E24E7A-A24B-4241-BA5E-022E3EDBDA1D") }); Assert.IsFalse(string.IsNullOrWhiteSpace(result)); }
public void FetchByJSONStringParamsTest() { SqlDataRequest dataRequest = new SqlDataRequest(ConnectionString); string result = dataRequest.Fetch("[dbo].[usp_Test_Select]", "{ Id : '69E24E7A-A24B-4241-BA5E-022E3EDBDA1D'}"); Assert.IsFalse(string.IsNullOrWhiteSpace(result)); }
public void FetchWithoutParamsTest() { SqlDataRequest dataRequest = new SqlDataRequest(ConnectionString); string result = dataRequest.Fetch("[dbo].[usp_Test_Select]"); Assert.IsFalse(string.IsNullOrWhiteSpace(result)); }
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); }