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);            
        }