خرید بک لینک

Vote count: 0

As you know we can use raw sql query in entity framework by SqlQuery() method or ExecuteSqlCommand() method. in addition we use raw sql query in ado.net for add, change or remove data in database. My question is way we use entity framework to execute raw sql queries while we can execute them by ado.net?

For example assume these codes:

ADO.NET:

    public bool CheckUseameAndPassword()
    {
        string coectionString = "Server=localhost;Database=Project;Trusted_Coection=True;MultipleActiveResultSets = true; ";

        loginQuery = "SELECT Users.*,Useame_Password.* "
            + "FROM Users "
            + "JOIN Useame_Password ON Useame_Password.Useame_Email = Users.Email "
            + "WHERE Useame_Password.Useame_Email = '" + _Useame + "' "
            + "AND Useame_Password.Password='" + _Password + "'";

            coection = new SqlCoection(coectionString);
            coection.Open();
            SqlCommand getinformationCommand = new SqlCommand(loginQuery, coection);
//Some Codes

Entity Framework:

    public void CheckUseameAndPassword()
    {
        using (var projectContext = new ProjectEntities())
        {
            string loginQuery = "SELECT Users.*,Useame_Password.* "
                    + "FROM Users "
                    + "JOIN Useame_Password ON Useame_Password.Useame_Email = Users.Email "
                    + "WHERE Useame_Password.Useame_Email = '" + _Useame + "' "
                    + "AND Useame_Password.Password='" + _Password + "'";

            string password = projectContext.Database.SqlQuery<string>(loginQuery).FirstOrDefault<string>();
//Some Codes

Both of these codes executes the same sql query.

Does it have special advantages to use entity framework's methods to execute sql queries?

thanks

asked 14 secs ago

برچسب: نویسنده: استخدام کار تاريخ: چهارشنبه 6 مرداد 1395 ساعت: 16:40

صفحه بندی