Example #1
0
        public void FetchByDynamicObjParamsTest()
        {
            SqlDataRequest dataRequest = new SqlDataRequest(ConnectionString);

            string result = dataRequest.Fetch("[dbo].[usp_Test_Select]", new { Id = idGuid });

            Assert.IsFalse(string.IsNullOrWhiteSpace(result));
        }
Example #2
0
        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));
        }
Example #3
0
        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);
        }