public HttpResponseMessage QueryProductsHttp(QueryDto query) { using (var conn = new SqlConnection(_connString)) { var product = conn.QueryFirstOrDefault <Products>("select * from products where productId = @productId", new { productId = query.ProductId }); product.ProductName = query.ProductName; return(Request.CreateResponse(HttpStatusCode.OK, product)); } }
public Products QueryProducts(QueryDto query) { using (var conn = new SqlConnection(_connString)) { var builder = new SqlBuilder(); var productBuilder = builder.AddTemplate("select * from products /**where**/"); if (query != null) { builder.Where("ProductId = @productId", new { ProductId = query.ProductId }); } var product = conn.QueryFirstOrDefault <Products>(productBuilder.RawSql, productBuilder.Parameters); return(product); } }