READMERepositoryEntity7.md

#Canducci EntityFramework 7.0.0-rc1 Repository

NUGET

PM> Install-Package Canducci.EntityFramework.Repository -Pre

##HOW TO?

Use namespace :

using Microsoft.Data.Entity;
using Canducci.EntityFramework.Repository.Contracts;
using Canducci.EntityFramework.Repository.Interfaces;

####Class:

public class Car
{
    public int Id { get; set; }
    public string Model { get; set; }
    public short Year { get; set; }
}


public class Database: DbContext
{
    public Database()
    {

    }

    protected override void OnConfiguring(DbContextOptionsBuilder optionsBuilder)
    {
        optionsBuilder.UseSqlServer("Server=.\\SQLExpress;Database=Mvc;User Id=sa;Password=senha;");
    }

    protected override void OnModelCreating(ModelBuilder modelBuilder)
    {
        modelBuilder.Entity<Car>()
            .ToTable("Cars");

        modelBuilder.Entity<Car>()
            .Property(x => x.Model)
            .IsRequired()
            .HasMaxLength(50);

        modelBuilder.Entity<Car>()
            .Property(x => x.Year)
            .IsRequired();

        modelBuilder.Entity<Car>()
            .Property(x => x.Id)
            .UseSqlServerIdentityColumn()
            .IsRequired();             


    }
}

####Class Repository

The Database: DbContext and Car: DbSet.

using Canducci.EntityFramework.Repository.Contracts;
namespace WebApplication1.Models
{
    
    public abstract class RepositoryCarContract:
        Repository<Car, Database>,
        IRepository<Car, Database>
    {
        public RepositoryCarContract(Database database)
            :base(database)
        {
        }
    }

    public sealed class RepositoryCar :
        RepositoryCarContract
    {
        public RepositoryCar(Database database)
            : base(database)
        {
        }
    }
}

In the Startup.cs:

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

    services.AddEntityFramework()
        .AddSqlServer();

    services.AddTransient<Database>();
    services.AddTransient<RepositoryCarContract, RepositoryCar>();

}

In the Controller:

using Microsoft.AspNet.Mvc;
using WebApplication6.Models;
namespace WebApplication6.Controllers
{
    public class CarsController : Controller
    {

        public readonly RepositoryCarContract repository;
        public CarsController(RepositoryCarContract repository)
        {
            this.repository = repository;
        }

        [HttpGet()]
        public IActionResult Index()
        {
            return View(repository.All(o => o.Id));
        }

        [HttpGet()]
        public IActionResult Create()
        {
            return View();
        }

        [HttpPost()]
        public IActionResult Create(Car car)
        {
            repository.Add(car);
            return RedirectToAction("Index");
        }

        [HttpGet()]
        public IActionResult Edit(int id)
        {
            return View(repository.Find(x => x.Id == id));
        }

        [HttpPost()]
        public IActionResult Edit(int id, Car car)
        {
            repository.Update(car);
            return RedirectToAction("Index");
        }

        [HttpGet()]
        public IActionResult Delete(int id)
        {
            repository.Remove(repository.Find(x => x.Id == id));
            return RedirectToAction("Index");
        }

    }
}