字符串拼接string.format新语法

最新推荐文章于 2024-08-14 12:23:12 发布

Hafywang

最新推荐文章于 2024-08-14 12:23:12 发布

阅读量725

点赞数

文章标签： c# .net mvc

本文链接：https://blog.csdn.net/weixin_36728104/article/details/73930967

版权

var where = $@" AND CONVERT(varchar(12),EnrollTime, 112 )  = { startTime }
                                AND TrainingInstitutionId = {trainingInstitutionId}";

                var sql = $@"SELECT COUNT(UserId) EnrollCount
	                    FROM dbo.T_EnrollUser 
	                    WHERE IsUsed = 1 AND IsDel = 0 {where}";
                var result = dbContext.Database.SqlQuery<EnrollCountForPie>(sql);