3 回答

TA贡献1829条经验 获得超4个赞
我认为如果您在sql server中使用存储过程会更好...您可以为查询创建一个
USE [DBName]
GO
/****** Object: StoredProcedure [dbo].[GetCode] Script Date: 03/05/2018 10:51:19 a.m. ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[GetCode]
(
@Left char
)
AS
BEGIN
SET NOCOUNT ON;
SELECT Code FROM Employee WHERE Employee.Left in (@Left)
END
...
然后,您可以通过以下方式从c#调用它:
private List<Type> GetCode(string Left)
{
List<Type> List = new List<Type>();
DbConnection();
con.Open();
DynamicParameters Parm = new DynamicParameters();
Parm.Add("@Left", Left, DbType.String, ParameterDirection.Input, 2);
//Parm.Add(nameOfParameter,valueOfParameter,typeOfParameter,directionOfParameter,sizeOfParameter);
List = SqlMapper.Query<Type>(con, "Entities.GetCode", Parm, commandType: CommandType.StoredProcedure).ToList();
con.Close();
return List;
}
- 3 回答
- 0 关注
- 271 浏览
添加回答
举报