本文整理汇总了C#中IUnitOfWork.Query方法的典型用法代码示例。如果您正苦于以下问题：C# IUnitOfWork.Query方法的具体用法？C# IUnitOfWork.Query怎么用？C# IUnitOfWork.Query使用的例子？那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类IUnitOfWork的用法示例。
在下文中一共展示了IUnitOfWork.Query方法的4个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的C#代码示例。
示例1: RegisterUser
public int RegisterUser(IList<BusinessObject.User> userInfor, IUnitOfWork unitOfWork)
{
ValidateUnitOfWork(unitOfWork);
string procedureName = "dbo.CreateUser";
var parameters = new SqlDynamicParameters();
parameters.AddAsTable("@User", userInfor);
var result = unitOfWork.Query<BusinessObject.User>(procedureName, parameters, commandType: CommandType.StoredProcedure);
return result == null? 0 : 1;
}示例2: SaveTopic
public int SaveTopic(IList<BusinessObject.Topic> topicInfo, IUnitOfWork unitOfWork)
{
ValidateUnitOfWork(unitOfWork);
string procedureName = "dbo.SaveTopic";
var parameters = new SqlDynamicParameters();
parameters.AddAsTable("@Topic", topicInfo);
var result = unitOfWork.Query<BusinessObject.Topic>(procedureName, parameters, commandType: CommandType.StoredProcedure);
return result == null? 0 : 1;
}示例3: GetTopicById
public BusinessObject.Topic GetTopicById(int topicId, IUnitOfWork unitOfWork)
{
ValidateUnitOfWork(unitOfWork);
string procedureName = "dbo.GetTopicById";
var parameters = new
{
TopicId = topicId
};
var result = unitOfWork.Query<BusinessObject.Topic>(procedureName, parameters, commandType: CommandType.StoredProcedure).SingleOrDefault();
return result;
}示例4: LoginUser
public BusinessObject.User LoginUser(UserLoginRequest userInfo, IUnitOfWork unitOfWork)
{
ValidateUnitOfWork(unitOfWork);
string procedureName = "dbo.GetUserLogin";
var parameters = new
{
UserName = userInfo.UserName,
Password = userInfo.Password
};
var result = unitOfWork.Query<BusinessObject.User>(procedureName, parameters, commandType: CommandType.StoredProcedure).SingleOrDefault();
return result;
}