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