大佬教程收集整理的这篇文章主要介绍了c# – 将值传递给ObjectParameter变量,大佬教程大佬觉得挺不错的,现在分享给大家,也给大家做个参考。
ALTER Procedure [dbo].[SaveInvitation] ( @InvitationID INT OUTPUT,@UserID INT,@Email NCHAR(100),@InvitationGUID UNIQUEIDENTIFIER OUTPUT ) AS
我的function.cs:
public SaveInvitation_Result SaveInvitation(int userID,string email) { SaveInvitation_Result result = null; var results = this.DataContext.SaveInvitation(null,userID,email,null); if (results != null) { result = results.FirstOrDefault(); } return result; }
我将一些参数传递给我的函数SaveInvitation,如下所示:
我的DataBaseModel.Designer.cs:
public ObjectResult<SaveInvitation_Result> SaveInvitation(ObjectParameter invitationID,Nullable<global::system.int32> userID,global::System.String email,ObjectParameter invitationGUID) { ObjectParameter userIDParameter; if (userID.HasValue) { userIDParameter = new ObjectParameter("UserID",userID); } else { userIDParameter = new ObjectParameter("UserID",typeof(global::system.int32)); } ObjectParameter emailParameter; if (email != null) { emailParameter = new ObjectParameter("Email",email); } else { emailParameter = new ObjectParameter("Email",typeof(global::System.String)); } return base.ExecuteFunction<SaveInvitation_Result>("SaveInvitation",invitationID,userIDParameter,emailParameter,invitationGUID); }
如何将值传递给invitationID和invitationGUID?
public ObjectResult<SaveInvitation_Result> SaveInvitation(ObjectParameter invitationID,ObjectParameter invitationGUID) { ObjectParameter userIDParameter; if (userID.HasValue) { userIDParameter = new ObjectParameter("UserID",userID); } else { userIDParameter = new ObjectParameter("UserID",typeof(global::system.int32)); userIDParameter.Value = DBNull.Value; } ObjectParameter emailParameter; if (email != null) { emailParameter = new ObjectParameter("Email",email); } else { emailParameter = new ObjectParameter("Email",typeof(global::System.String)); emailParameter.Value = DBNull.Value; } return base.ExecuteFunction<SaveInvitation_Result>("SaveInvitation",invitationGUID); }
以上是大佬教程为你收集整理的c# – 将值传递给ObjectParameter变量全部内容,希望文章能够帮你解决c# – 将值传递给ObjectParameter变量所遇到的程序开发问题。
如果觉得大佬教程网站内容还不错,欢迎将大佬教程推荐给程序员好友。
本图文内容来源于网友网络收集整理提供,作为学习参考使用,版权属于原作者。
如您有任何意见或建议可联系处理。小编QQ:384754419,请注明来意。