初識(shí)ASP.NET Mvc5+EF7的奇妙之旅

 "dependencies": {
 "Microsoft.AspNet.Server.IIS": "1.0.0-beta7",
 "Microsoft.AspNet.Server.WebListener": "1.0.0-beta7",
 "Microsoft.AspNet.StaticFiles": "1.0.0-beta7",
 "Microsoft.AspNet.Mvc": "6.0.0-beta7",
 "EntityFramework.Commands": "7.0.0-beta7",
 "EntityFramework.SqlServer": "7.0.0-beta7",
 "Microsoft.Framework.Configuration.Json": "1.0.0-beta7",
 "Microsoft.Framework.Configuration.UserSecrets": "1.0.0-beta7"
 },

 "commands": {
 "web": "Microsoft.AspNet.Hosting --config hosting.ini",
 "ef": "EntityFramework.Commands"
 },

using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;

namespace MusicBank.Models
{
 public class Artist
 {
  [Key]
  [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
  public Guid Id { get; set; }
  [Required]
  public string Name { get; set; }
  [Required]
  public int Age { get; set; }
  public virtual ListAudio> Audio { get; set; }
 }
}

using Microsoft.Data.Entity;

namespace MusicBank.Models
{
 public class MusicContext : DbContext
 {
  public DbSetAudio> Audio { get; set; }
  public DbSetArtist> Artists { get; set; }
 }
}

using Microsoft.Framework.DependencyInjection;
using System;
using System.Linq;

namespace MusicBank.Models
{
 public class SampleData
 {
  public static void Initialize(IServiceProvider serviceProvider)
  {
   var context = serviceProvider.GetServiceMusicContext>();
   if (context.Database.EnsureCreated())
   {
    if (!context.Artists.Any())
    {
     var austen = context.Artists.Add(
      new Artist { Name = "Austen", Age = 21 }).Entity;
     var dickens = context.Artists.Add(
      new Artist { Name = "Dickens", Age = 25 }).Entity;
     var cervantes = context.Artists.Add(
      new Artist { Name = "Cervantes", Age = 27 }).Entity;

     context.Audio.AddRange(
      new Audio()
      {
       Name = "Pride",
       Type = 1,
       Artist = austen,
       Src = "Pride.mp3"
      },
      new Audio()
      {
       Name = "Northanger",
       Type = 2,
       Artist = austen,
       Src = "Northanger.mp3"
      },
      new Audio()
      {
       Name = "David",
       Type = 3,
       Artist = dickens,
       Src = "David.mp3"
      },
      new Audio()
      {
       Name = "DonQuixote",
       Type = 1,
       Artist = cervantes,
       Src = "DonQuixote.mp3"
      }
     );
     context.SaveChanges();
    }
   }
  }
 }
}

if (context.Database.EnsureCreated())

{
 "Data": {
 "MusicConnection": {
  "ConnectionString": "Server=(localdb)\\mssqllocaldb;Database=MusicBank-Database;Trusted_Connection=True;MultipleActiveResultSets=true"
 }
 }
}

using Microsoft.AspNet.Builder;
using Microsoft.AspNet.Hosting;
using Microsoft.Data.Entity;
using Microsoft.Dnx.Runtime;
using Microsoft.Framework.Configuration;
using Microsoft.Framework.DependencyInjection;
using MusicBank.Models;

namespace MusicBank
{
 public class Startup
 {
  public Startup(IHostingEnvironment env, IApplicationEnvironment appEnv)
  {
   var builder = new ConfigurationBuilder(appEnv.ApplicationBasePath)
    .AddJsonFile("config.json")
    .AddJsonFile($"config.{env.EnvironmentName}.json", optional: true);

   builder.AddEnvironmentVariables();
   Configuration = builder.Build();
  }
  public IConfigurationRoot Configuration { get; set; }

  public void ConfigureServices(IServiceCollection services)
  {
   services.AddMvc();

   services.AddEntityFramework()
    .AddSqlServer()
    .AddDbContextMusicContext>(options =>
    {
     options.UseSqlServer(Configuration["Data:MusicConnection:ConnectionString"]);
    });
  }

  public void Configure(IApplicationBuilder app, IHostingEnvironment env)
  {
   app.UseStaticFiles();
   app.UseMvc();

   SampleData.Initialize(app.ApplicationServices);
  }
 }
}

using Microsoft.AspNet.Mvc;
using MusicBank.Models;
using System.Collections.Generic;
using System.Linq;

namespace MusicBank.Controllers
{
 [Route("api/[controller]")]
 public class AudioController : Controller
 {
  [FromServices]
  public MusicContext db { get; set; }

  [HttpGet]
  public IEnumerableAudio> Get()
  {
   return db.Audio.ToList();
  }

  [HttpGet("{name}")]
  public Audio Get(string name)
  {
   Audio audio = db.Audio.Where(a => (a.Name == name)).FirstOrDefault();
   return audio;
  }
 }
}

 "web": "Microsoft.AspNet.Hosting --config hosting.ini",

server=Microsoft.AspNet.Server.WebListener
server.urls=http://localhost:5000