How to use DbContext.Database.SqlQuery(sql, params) with stored procedure? EF Code First CTP5

by

You should supply the SqlParameter instances in the following way: 

context.Database.SqlQuery<myEntityType>(
    "mySpName @param1, @param2, @param3",
    new SqlParameter("param1", param1),
    new SqlParameter("param2", param2),
    new SqlParameter("param3", param3)
);

More Related Contents:

  1. How can I add user-supplied input to an SQL statement?
  2. Pass table valued parameter using ADO.NET
  3. Is it necessary to manually close and dispose of SqlDataReader?
  4. How to save image in database using C# [closed]
  5. SqlBulkCopy from a List
  6. How to fill Dataset with multiple tables?
  7. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  8. How do I translate a List into a SqlParameter for a Sql In statement? [duplicate]
  9. Add WHERE clauses to SQL dynamically / programmatically
  10. Calling a SQL User-defined function in a LINQ query
  11. Check if a SQL table exists
  12. Enabling Foreign key constraints in SQLite
  13. How to use SQL ‘LIKE’ with LINQ to Entities? [duplicate]
  14. How do I extract data from a DataTable?
  15. How to give ADO.NET Parameters
  16. Do we have transactions in MS-Access?
  17. I want to insert a record in DB and then need to return a row
  18. ExecuteReader requires an open and available Connection. The connection’s current state is Connecting
  19. What is the syntax for an inner join in LINQ to SQL?
  20. LINQ to Entities does not recognize the method ‘System.String ToString()’ method, and this method cannot be translated into a store expression
  21. ‘Contains()’ workaround using Linq to Entities?
  22. NHibernate QueryOver with Fetch resulting multiple sql queries and db hits
  23. What represents a double in sql server?
  24. Distinct in Linq based on only one field of the table
  25. Executing query with parameters
  26. How can I retrieve a list of parameters from a stored procedure in SQL Server
  27. Getting the Last Insert ID with SQLite.NET in C#
  28. Join and Include in Entity Framework
  29. Using SqlDataAdapter to insert a row
  30. Generating sql code programmatically

Leave a Comment