How to pass parameters to the DbContext.Database.ExecuteSqlCommand method?

by

Try this:

var sql = @"Update [User] SET FirstName = @FirstName WHERE Id = @Id";

ctx.Database.ExecuteSqlCommand(
    sql,
    new SqlParameter("@FirstName", firstname),
    new SqlParameter("@Id", id));

More Related Contents:

  1. Code-first vs Model/Database-first [closed]
  2. The relationship could not be changed because one or more of the foreign-key properties is non-nullable
  3. Should I enable or disable dynamic proxies with entity framework 4.1 and MVC3?
  4. How do I detach objects in Entity Framework Code First?
  5. ADO.NET DbContext Generator vs. ADO.NET Poco Entity Generator (ObjectContext)
  6. How to include a child object’s child object in Entity Framework 5
  7. Order navigation properties when using Include and/or Select methods with EF 4.1 Code-First?
  8. Entity framework code-first null foreign key
  9. How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
  10. Ramifications of DbSet.Create versus new Entity()
  11. Entity Framework 4.1 default eager loading
  12. EF Code First DBContext and Transactions
  13. How to update not every fields of an object using Entity Framework and EntityState.Modified
  14. Entity Framework Code First : Setting up One-To-One foreign key association using Annotations
  15. EF 4.1 loading filtered child collections not working for many-to-many
  16. Entity Framework Validation confusion – maximum string length of ‘128’
  17. Using the Entry().CurrentValues.SetValues() is not updating collections
  18. Entity Framework Code First Many to Many Setup For Existing Tables
  19. Entity Framework: One Database, Multiple DbContexts. Is this a bad idea? [closed]
  20. Entity Framework and SQL Server View
  21. How to filter nested collection Entity Framework objects?
  22. Unique keys in Entity Framework 4
  23. How to map table splitting in EF Code First?
  24. Entity Framework: Re-finding objects recently added to context
  25. ObjectContext.Refresh()?
  26. How do I map a char property using the Entity Framework 4.1 “code only” fluent API?
  27. mapping private property entity framework code first [duplicate]
  28. How to create index in Entity Framework 6.2 with fluent configuration
  29. Map two different entities to the same table?
  30. Nullable property to entity field, Entity Framework through Code First

Leave a Comment