MVC 4 - Razor (EntityFramework)

EntityFramework

For MVC 4 

• Install EntityFramework v5
• install-package EntityFramework -version 5.0 using the console

Create a Context

• Create a class in the Model folder that extends from : DbContext

using System.Data.Entity; 

namespace PhotoSharingApplication.Models

{

    public class PhotoSharingContext : DbContext 

    {

        public DbSet<Photo> Photos

        { get; set; }

        public DbSet<Comment> Comments

        { get; set; } 

    }

}

Entity Framework Initializer

• Create the initializer and create the initials objects

using System; using System.Collections.Generic; using System.Data.Entity; using System.IO; using System.Linq; using System.Web; namespace PhotoSharingApplication.Models { public class PhotoSharingInitializer : DropCreateDatabaseAlways<PhotoSharingContext> { //This method puts sample data into the database protected override void Seed(PhotoSharingContext context) { base.Seed(context); //Create some photos var photos = new List<Photo> { new Photo { Title = "Me standing on top of a mountain", Description = "I was very impressed with myself", UserName = "Fred", PhotoFile = getFileBytes("\\Images\\flower.jpg"), ImageMimeType = "image/jpeg", CreatedDate = DateTime.Today }, new Photo { Title = "My New Adventure Works Bike", Description = "It's the bees knees!", UserName = "Fred", PhotoFile = getFileBytes("\\Images\\orchard.jpg"), ImageMimeType = "image/jpeg", CreatedDate = DateTime.Today }, new Photo { Title = "View from the start line", Description = "I took this photo just before we started over my handle bars.", UserName = "Sue", PhotoFile = getFileBytes("\\Images\\path.jpg"), ImageMimeType = "image/jpeg", CreatedDate = DateTime.Today } }; photos.ForEach(s => context.Photos.Add(s)); context.SaveChanges(); //Create some comments var comments = new List<Comment> { new Comment { PhotoID = 1, UserName = "Bert", Subject = "A Big Mountain", Body = "That looks like a very high mountain you have climbed" }, new Comment { PhotoID = 1, UserName = "Sue", Subject = "So?", Body = "I climbed a mountain that high before breakfast everyday" }, new Comment { PhotoID = 2, UserName = "Fred", Subject = "Jealous", Body = "Wow, that new bike looks great!" } }; comments.ForEach(s => context.Comments.Add(s)); context.SaveChanges(); } //This gets a byte array for a file at the path specified //The path is relative to the route of the web site //It is used to seed images private byte[] getFileBytes(string path) { FileStream fileOnDisk = new FileStream(HttpRuntime.AppDomainAppPath + path, FileMode.Open); byte[] fileBytes; using (BinaryReader br = new BinaryReader(fileOnDisk)) { fileBytes = br.ReadBytes((int)fileOnDisk.Length); } return fileBytes; } } }

• Global.asax - Add the initializer

protected void Application_Start()

        {

            Database.SetInitializer<PhotoSharingContext>(new PhotoSharingInitializer());

        }

• Add the connection String in Web.config

The name should be as the Context class

<connectionStrings>

    <add name="PhotoSharingContext"

     connectionString = "Server=tcp:rodrigo.database.windows.net,1433;Initial Catalog=PhotoSharingDB;Persist Security Info=False;User ID=rodrigo;Password=Pa$$w0rd;MultipleActiveResultSets=False;Encrypt=True;TrustServerCertificate=False;Connection Timeout=30;"

     providerName =  

        "System.Data.SqlClient" />

    

  </connectionStrings>