使用带有Lambda Expression的linQ删除记录 [英] Delete record using linQ with lambda Expression

问题描述

我想使用linq lambda表达式删除sql数据库的记录.我该怎么办?

I want to delete records of sql database using linq lambda expression. What should I do?

"student"是我的表，"db"是.edmx文件的对象

Here 'student' is my table and 'db' is object of .edmx file

public bool DeleteRecord(int caurseID)
{
    studentEntities db = new studentEntities();

    int count = db.student.Where(s => s.caurse_id == caurseID).Count();

    if (count != 0)
    {
        //string subQuery = "delete from student where caurse_id=" + caurseID;
        //SqlCommand subCmd = new SqlCommand(subQuery, conn);
        //subCmd.ExecuteNonQuery();
        db.student. : For Delete, what will be goes here???
    }

    return true;
}

推荐答案

我从先前的建议中获得了参考.

I got reference from previous suggestion.

studentEntities db_dlt = new studentEntities();
                var students = db_dlt.student.FirstOrDefault(s => s.caurse_id == caurseID);
                if (students != null)
                {
                    db_dlt.student.Remove(students);
                    db_dlt.SaveChanges();
                }

这篇关于使用带有Lambda Expression的linQ删除记录的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！