这句sql如何翻译成linq?

sql=“select Code, StudentName  from [Student]”
if(TeacherName!=""){
sql+=" ,[Teacher] where [Student].TeacherName = [Teacher] .TeacherName Where         [Teacher].TeacherName=TeacherName"
}

回答

            var teacherName = string.Empty;
            var teachers = new List<(string Code, string TeacherName)>();
            new List<(string Code, string StudentName, string TeacherName)>()
                .Where(t => !string.IsNullOrEmpty(teacherName) && teachers.Any(g => g.TeacherName == teacherName));

闲来无聊,预计是这么个意思,送一下代码。

以上是这句sql如何翻译成linq?的全部内容。
THE END
分享
二维码
< <上一篇
下一篇>>