c＃处理数据上下文
|
3个具有相同功能的示例：
方法1
使用大括号
public static int TicketsRequiringSupportResponse()
{
int ReturnValue = 0;
using (var dc = new CrystalCommon.MainContext())
{
ReturnValue = (dc.tblHelpCentreQuestions.Where(c => c.awaitingSupportResponse == true).Count());
}
return ReturnValue;
}
public static int TicketsRequiringSupportResponse()
{
int ReturnValue = 0;
using (var dc = new CrystalCommon.MainContext())
ReturnValue = (dc.tblHelpCentreQuestions.Where(c => c.awaitingSupportResponse == true).Count());
return ReturnValue;
}
public static int TicketsRequiringSupportResponse()
{
using (var dc = new CrystalCommon.MainContext())
return (dc.tblHelpCentreQuestions.Where(c => c.awaitingSupportResponse == true).Count());
}
没有找到相关结果
已邀请:
4 个回复
视蕉梁拌客
谷靛
坛沤疲撑拆
int ReturnValue = 0; Context dc = null; try { dc = new CrystalCommon.MainContext(); ReturnValue = (dc.tblHelpCentreQuestions.Where(c => c.awaitingSupportResponse == true).Count()); } finally { if(dc != null) dc.Dispose(); } return ReturnValue;Context dc = null; try { dc = new CrystalCommon.MainContext(); return (dc.tblHelpCentreQuestions.Where(c => c.awaitingSupportResponse == true).Count()); } finally { if(dc != null) dc.Dispose(); }寒健
public static int TicketsRequiringSupportResponse() { using (var dataContext = new CrystalCommon.MainContext()) { return dataContext .tblHelpCentreQuestions.Where( question => question.awaitingSupportResponse == true).Count(); } }