public void FetchByJSONStringParamsTest() { SqlDataRequest dataRequest = new SqlDataRequest(ConnectionString); string result = dataRequest.Fetch("[dbo].[usp_Test_Select]", JsonConvert.SerializeObject(new { Id = idGuid })); Assert.IsFalse(string.IsNullOrWhiteSpace(result)); }
public void FetchByDynamicObjParamsTest() { SqlDataRequest dataRequest = new SqlDataRequest(ConnectionString); string result = dataRequest.Fetch("[dbo].[usp_Test_Select]", new { Id = idGuid }); Assert.IsFalse(string.IsNullOrWhiteSpace(result)); }
public async Task FetchasyncTest() { SqlDataRequest dataRequest = new SqlDataRequest(ConnectionString); string result = await dataRequest.FetchAsync("[dbo].[usp_Test_Select]", new { Id = idGuid }); Assert.IsFalse(string.IsNullOrWhiteSpace(result)); }
public void FetchWithoutParamsTest() { SqlDataRequest dataRequest = new SqlDataRequest(ConnectionString); string result = dataRequest.Fetch("[dbo].[usp_Test_Select]"); var token = JToken.Parse(result); Assert.IsTrue(token is JArray); }
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 async Task JsonStringHurlAsyncTest() { SqlDataRequest dataRequest = new SqlDataRequest(ConnectionString); var obj2 = new { Id = Guid.NewGuid(), Name = string.Format("Test Async:{0}", DateTime.Now.ToLongDateString()), Description = string.Format("Description Async:{0}", DateTime.Now.ToLongDateString()), Details = string.Format("Details Async:{0}", DateTime.Now.ToLongDateString()), RecordedDate = DateTime.Now, IsActive = true }; int rowsAffected2 = await dataRequest.HurlAsync("[dbo].[usp_Test_Insert]", JsonConvert.SerializeObject(obj2)); Assert.IsTrue(rowsAffected2 > 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); }