没有实体框架的MVC [英] MVC with no Entity Framework

问题描述

来自以下源教程：

• https://www.youtube.com/watch?v=Jt9vSY802mM


• http://www.dotnetawesome.com/2017/07/curd-operation-on -fullcalendar-in-aspnet-mvc.html

• https://www.youtube.com/watch?v=Jt9vSY802mM
• http://www.dotnetawesome.com/2017/07/curd-operation-on-fullcalendar-in-aspnet-mvc.html

如何在没有实体框架的情况下执行上述代码示例，作者：只是使用SQL查询？

How do I do the above code samples without Entity Framework, by just using SQL queries?

例如在上述源代码中，而不是

For example in the above source code, instead of

var v = dc.Events.Where(a => a.EventID == eventID).FirstOrDefault();  

if (v != null)
{
    dc.Events.Remove(v);
    dc.SaveChanges();
    status = true;
}

我想做

DELETE FROM Even WHERE EventID = {0}

推荐答案

方式的组合：

1. 在实体框架中使用原始查询：


2. 通过SqlConnection打开连接字符串并执行：

方法1的sudo代码：

sudo code for method 1:

string sqlDeleteStatement = "DELETE FROM Even WHERE EventID = @id";
List<SqlParameter> parameterList = new List<SqlParameter>();
parameterList.Add(new SqlParameter("@id", 1)); delete id = 1
_context.Database.SqlQuery(sqlDeleteStatement, parameterList);

方法2的伪代码：

using(SqlConnection conn = new SqlConnection()) 
{
   conn.ConnectionString = "Server=[server_name];Database=[database_name];Trusted_Connection=true";
   string sqlDeleteStatement = "DELETE FROM Even WHERE EventID = @id";
   SqlCommand command = new SqlCommand(sqlDeleteStatement , conn);
   command.Parameters.Add(new SqlParameter("@id", 1)); //delete id = 1
   command.ExecuteNonQuery();
}

这篇关于没有实体框架的MVC的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！