Can you create sql views / stored procedure using Entity Framework 4.1 Code first approach

by

We support stored procedures in our Entity Framework Code First Migrations. Our approach is to create some folder to hold the .sql files (~/Sql/ for example). Create .sql files in the folder for both creating and dropping the stored procedure. E.g. Create_sp_DoSomething.sql and Drop_sp_DoSomething. Because the SQL runs in a batch and CREATE PROCEDURE.. must be the first statement in a batch, make the CREATE PROCEDURE... the first statement in the file. Also, don’t put GO after the DROP.... Add a resources file to your project, if you don’t have one already. Drag the .sql files from solution explorer into the Files view of the Resources designer. Now create an empty migration (Add-Migration SomethingMeaningful_sp_DoSomething) and use:

namespace MyApplication.Migrations
{
    using System;
    using System.Data.Entity.Migrations;

    public partial class SomethingMeaningful_sp_DoSomething : DbMigration
    {
        public override void Up()
        {
            this.Sql(Properties.Resources.Create_sp_DoSomething);
        }

        public override void Down()
        {
            this.Sql(Properties.Resources.Drop_sp_DoSomething);
        }
    }
}

~/Sql/Create_sp_DoSomething.sql

CREATE PROCEDURE [dbo].[sp_DoSomething] AS
BEGIN TRANSACTION
-- Your stored procedure here
COMMIT TRANSACTION
GO

~/Sql/Drop_sp_DoSomething.sql

DROP PROCEDURE [dbo].[sp_DoSomething]

More Related Contents:

  1. Entity Framework Code First – two Foreign Keys from same table
  2. Entity Framework Code First Date field creation
  3. Validation failed for one or more entities. See ‘EntityValidationErrors’ property for more details [duplicate]
  4. Unique key with EF code first
  5. Entity Framework Join 3 Tables
  6. Why use ICollection and not IEnumerable or List on many-many/one-many relationships?
  7. How to retrieve Data Annotations from code? (programmatically)
  8. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  9. Entity Framework DateTime and UTC
  10. Does Entity Framework Code First support stored procedures?
  11. Why is inserting entities in EF 4.1 so slow compared to ObjectContext?
  12. Generic Way to Check If Entity Exists In Entity Framework?
  13. Overriding SaveChanges and setting ModifiedDate, but how do I set ModifiedBy?
  14. EF Code First – how to set identity seed?
  15. Understanding ForeignKey attribute in entity framework code first
  16. Mapping Database Views to EF 5.0 Code First w/Migrations
  17. Entity Framework 4.1 InverseProperty Attribute
  18. EF migration for changing data type of columns
  19. How to configure many to many relationship using entity framework fluent API
  20. EF5 Code First – Changing A Column Type With Migrations
  21. Entity Framework 4.1 InverseProperty Attribute and ForeignKey
  22. Self-referencing many-to-many recursive relationship code first Entity Framework
  23. EF4 Code First: how to add a relationship without adding a navigation property
  24. GUID COMB strategy in EF
  25. An error occurred while saving entities that do not expose foreign key properties for their relationships
  26. Can you get the DbContext from a DbSet?
  27. What is the difference between IDbSet.Add and DbEntityEntry.State = EntityState.Added?
  28. DbSet table name
  29. mapping multiple tables to a single entity class in entity framework
  30. Entity Framework 4.1 DbSet Reload

Leave a Comment