Ir al contenido principal

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>



Comentarios

Publicar un comentario

Entradas populares de este blog

Android - Basic Steps (Notifications)

User Notifications Types: Toast Notification Area Notifications Tip To use the notification vibration, establish the permission in the AndroidManifest.xml file    <uses-permission android:name="android.permission.VIBRATE" >     </uses-permission> Broadcast Base class for components that receive and react to events When event occur is represented as Intent, then are broadcast to system The Intent routes to BroadcastReceiver The BroadcastReceiver receive on the method onReceive() Broadcast Events can be broadcast in Order or Normal way Normal - Undefined order and if there are two or more BroadcastReceivers can process the event at the same time. Order - Deliver the intent one at the time in priority order Can also be Sticky or Not Sticky Sticky   Store intent after initial broadcast Is useful to record system changes like the battery status Is disposed after the event finish  Non Stick...
Publicar un comentario
Leer más

BI - SSIS ( Basics I )

SSIS - Basic Concepts Tasks Bulk Insert Task—Loads data into a table by using the BULK INSERT SQL command. Data Flow Task—This is the most important task that loads and transforms data into an OLE DB Destination. Execute Package Task—Enables you to execute a package from within a package, making your SSIS packages modular. Execute Process Task—Executes a program external to your package, like one to split your extract file into many files before processing the individual files. Execute SQL Task—Executes a SQL statement or stored procedure. File System Task—This task can handle directory operations like creating, renaming, or deleting a directory. It can also manage file operations like moving, copying, or deleting files. FTP Task—Sends or receives files from an FTP site. Script Task—Runs a set of VB.NET or C# coding inside a Visual Studio environment. Send Mail Task—Sends a mail message through SMTP. Analysis Services Processing Task—This task processes a SQL Server A...
Publicar un comentario
Leer más

Android - Basic Steps (Service)

Service Run in the main thread of the hosting application Android can kill the Service if need the resources Purpose Supporting inter-application method execution Performing background processing Start a Service Call Context.startService(Intent intent)\ To call from a Fragment use getActivity().getApplicationContext().startService( intentService); Executing the service After call startService(...)  In the Service is executed the method onStartCommand(...) If the method returns the constant START_NOT_STICKY then Android will not restart the service automatically if the the process is killedp Foreground To execute the service foreground call the method startForeground() Use this if the user is aware of the process Bind to a Service Call the method Context.bindService( Intent service ServiceConnection con int flags ) Send Toast from the Service On the method onStartCommand receive the message   ...
Publicar un comentario
Leer más