a.
Microsoft.EntityFrameworkCore.SqlServer
b.
Microsoft.EntityFrameworkCore.SqlServer.Design
c.
Microsoft.EntityFrameworkCore.Tools
//CustomerController.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Mvc;
using ClassLibrary1;
// For more information on enabling Web API for empty projects, visit http://go.microsoft.com/fwlink/?LinkID=397860
namespace api_core.Controllers
{
[Route("api/[controller]")]
public class CustomerController : Controller
{
manager M;
public CustomerController(db_context context)
{
M = new manager(context);
}
// GET: api/values
[HttpGet]
public IEnumerable<dto> Get()
{
return M.GetAll();
}
// GET api/values/5
[HttpGet("{id}")]
public dto Get(int id)
{
return M.Find(id);
}
// POST api/values
[HttpPost]
public void Post([FromBody]string value)
{
}
// PUT api/values/5
[HttpPut("{id}")]
public void Put(int id, [FromBody]string value)
{
}
// DELETE api/values/5
[HttpDelete("{id}")]
public void Delete(int id)
{
}
}
}
--------------------------------------------------
//appsettings.json
{
"Logging": {
"IncludeScopes": false,
"LogLevel": {
"Default": "Debug",
"System": "Information",
"Microsoft": "Information"
}
},
"ConnectionStrings": {
"db_contextConnection": "server=localhost;database=OrdersDb;Integrated Security=True;"
}
}
------------------------------------------------
//startup.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
using Microsoft.AspNetCore.Builder;
using Microsoft.AspNetCore.Hosting;
using Microsoft.Extensions.Configuration;
using Microsoft.Extensions.DependencyInjection;
using Microsoft.Extensions.Logging;
using ClassLibrary1;
using Microsoft.EntityFrameworkCore;
namespace api_core
{
public class Startup
{
public Startup(IHostingEnvironment env)
{
var builder = new ConfigurationBuilder()
.SetBasePath(env.ContentRootPath)
.AddJsonFile("appsettings.json", optional: true, reloadOnChange: true)
.AddJsonFile($"appsettings.{env.EnvironmentName}.json", optional: true)
.AddEnvironmentVariables();
Configuration = builder.Build();
}
public IConfigurationRoot Configuration { get; }
// This method gets called by the runtime. Use this method to add services to the container.
public void ConfigureServices(IServiceCollection services)
{
// Add framework services.
services.AddMvc();
var cs = Configuration.GetConnectionString("db_contextConnection");
services.AddDbContext<db_context>(options =>
options.UseSqlServer(cs));
}
// This method gets called by the runtime. Use this method to configure the HTTP request pipeline.
public void Configure(IApplicationBuilder app, IHostingEnvironment env, ILoggerFactory loggerFactory)
{
loggerFactory.AddConsole(Configuration.GetSection("Logging"));
loggerFactory.AddDebug();
app.UseMvc();
}
}
}
---------------------------------------------------------
//~/api_core/project.json
{
"dependencies": {
"Microsoft.NETCore.App": {
"version": "1.0.1",
"type": "platform"
},
"Microsoft.AspNetCore.Mvc": "1.0.1",
"Microsoft.AspNetCore.Routing": "1.0.1",
"Microsoft.AspNetCore.Server.IISIntegration": "1.0.0",
"Microsoft.AspNetCore.Server.Kestrel": "1.0.1",
"Microsoft.Extensions.Configuration.EnvironmentVariables": "1.0.0",
"Microsoft.Extensions.Configuration.FileExtensions": "1.0.0",
"Microsoft.Extensions.Configuration.Json": "1.0.0",
"Microsoft.Extensions.Logging": "1.1.0",
"Microsoft.Extensions.Logging.Console": "1.0.0",
"Microsoft.Extensions.Logging.Debug": "1.0.0",
"Microsoft.Extensions.Options.ConfigurationExtensions": "1.0.0",
"Microsoft.EntityFrameworkCore.Tools": "1.1.0-preview4-final",
"Microsoft.EntityFrameworkCore.SqlServer.Design": "1.1.0",
"Microsoft.EntityFrameworkCore.SqlServer": "1.1.0",
"ClassLibrary1": "1.0.0-*"
},
"tools": {
"Microsoft.AspNetCore.Server.IISIntegration.Tools": "1.0.0-preview2-final"
},
"frameworks": {
"netcoreapp1.0": {
"imports": [
"dotnet5.6",
"portable-net45+win8"
]
}
},
"buildOptions": {
"emitEntryPoint": true,
"preserveCompilationContext": true
},
"runtimeOptions": {
"configProperties": {
"System.GC.Server": true
}
},
"publishOptions": {
"include": [
"wwwroot",
"**/*.cshtml",
"appsettings.json",
"web.config"
]
},
"scripts": {
"postpublish": [ "dotnet publish-iis --publish-folder %publish:OutputPath% --framework %publish:FullTargetFramework%" ]
}
}
--------------------------------------------------
//db_context.cs
using Microsoft.EntityFrameworkCore;
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
namespace ClassLibrary1
{
public class db_context: DbContext
{
public db_context(DbContextOptions<db_context> options) : base(options){ }
public DbSet<customer> Customers { get; set; }
public DbSet<order> Orders { get; set; }
}
}
-------------------------------------------------
//manager.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
namespace ClassLibrary1
{
public class manager
{
db_context DB;
public manager(db_context context)
{
DB = context;
}
public IList<dto> GetAll()
{
return DB.Customers.Select(c => new dto
{
Id = c.Id,
City = c.City,
FirstName = c.FirstName,
LastName = c.LastName
}).ToList();
}
public dto Find(int id)
{
var c = DB.Customers.Find(id);// SingleOrDefault(x => x.Id == id);
var cust = new dto
{
Id = c.Id,
City = c.City,
FirstName = c.FirstName,
LastName = c.LastName
};
return cust;
}
}
}
-----------------------------------------------
//customer.cs
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Threading.Tasks;
namespace ClassLibrary1
{
public class customer
{
public int Id { get; set; }
[Required]
public string FirstName { get; set; }
[Required]
public string LastName { get; set; }
public string City { get; set; }
//navigation property
public virtual ICollection<order> Orders { get; set; }
}
}
-----------------------------------------------
//order.cs
using System;
using System.Collections.Generic;
using System.ComponentModel.DataAnnotations;
using System.Linq;
using System.Threading.Tasks;
namespace ClassLibrary1
{
public class order
{
public int Id { get; set; }
[Required]
public DateTime OrderDate { get; set; }
[Required]
public decimal OrderTotal { get; set; }
public int CustomerId { get; set; }
//navigation property
public virtual customer Customer { get; set; }
}
}
-----------------------------------------------------
//dto.cs
using System;
using System.Collections.Generic;
using System.Linq;
using System.Threading.Tasks;
namespace ClassLibrary1
{
public class dto
{
public int Id { get; set; }
public string FirstName { get; set; }
public string LastName { get; set; }
public string City { get; set; }
}
}
---------------------------------------------------
//~/classlibrary1/project.json
{
"version": "1.0.0-*",
"dependencies": {
"Microsoft.EntityFrameworkCore.SqlServer": "1.1.0",
"Microsoft.EntityFrameworkCore.SqlServer.Design": "1.1.0",
"Microsoft.EntityFrameworkCore.Tools": "1.1.0-preview4-final",
"NETStandard.Library": "1.6.1"
},
"frameworks": {
"netstandard1.6": {
"imports": "dnxcore50"
}
}
}
--------------------------------------------------
No comments:
Post a Comment