How can i see execute command in Entity FrameWork ?

Question

i try to use erpCtx.Executecommand but i doesn't have method of executecommand. i think that i must add dll in Reference to show executeCommand?

i need : int rowsAffected = engCtx.ExecuteCommand("insert into ENG_MAINWP Values({0},{1},{2},{3})", engArray[0], engArray1, engArray[2], engArray[3]);

Answer 1

Something like this?

 using (var db = new DAL.CrawlerDalEntities())
        {
            db.Connection.Open();
            using (var cmd = db.Connection.CreateCommand())
            {
                cmd.CommandTimeout = storedProcedureDefaultTimeout;
                cmd.CommandType = CommandType.StoredProcedure;
                cmd.CommandText = "CrawlerDalEntities.PerformBackup";

                cmd.Parameters.Add(new EntityParameter
                {
                    ParameterName = "fileName",
                    Value = fileName,
                    DbType = DbType.String
                });

                cmd.Parameters.Add(new EntityParameter
                {
                    ParameterName = "backupName",
                    Value = backupName,
                    DbType = DbType.String
                });

                cmd.ExecuteNonQuery();
            }
            db.Connection.Close();
        }

Answer 2

In the Entity Framework, it's called ExecuteStoreCommand.

Answer 3

DataContext.ExecuteCommand is in:

Namespace: System.Data.Linq
Assembly: System.Data.Linq (in System.Data.Linq.dll)

Source