22 lines
551 B
C#
22 lines
551 B
C#
using System;
|
|
using System.Collections.Generic;
|
|
using System.Configuration;
|
|
using System.Data.SqlClient;
|
|
using Dapper;
|
|
|
|
namespace hello.service
|
|
{
|
|
public class MsSqlService
|
|
{
|
|
public IEnumerable<model.Product> GetClient()
|
|
{
|
|
string connectionString = "";
|
|
using(var sqlconn=new SqlConnection(connectionString))
|
|
{
|
|
sqlconn.Open();
|
|
var products= sqlconn.Query<model.Product>("select * from product");
|
|
return products;
|
|
}
|
|
}
|
|
}
|
|
} |