public void Run()
{
using (var ctx = new PeopleContext())
{
ctx.People.Add(new Person {Id = 1, Name = "John Doe"});
ctx.SaveChanges();
}
using (var ctx = new PeopleContext())
{
Person person = ctx.People.SingleOrDefault(p => p.Id == 1);
Console.WriteLine(person.Name);
}
}
public HomeController(ILogger <HomeController> logger, PeopleContext peopleContext)
{
_logger = logger;
_peopleContext = peopleContext;
}
public PropertyController(IRepository <Property> propertyRepository, IMapper mapper, PeopleContext peopleContext)
{
this.propertyRepository = propertyRepository;
this.mapper = mapper;
this.peopleContext = peopleContext;
}
public PeopleHub(ILogger <PeopleHub> logger, PeopleContext context)
{
_logger = logger;
_context = context;
}
public PeopleController(PeopleContext db)
{
_db = db;
}
public PeopleController(PeopleContext context)
{
_context = context;
}
public PersonRepository(PeopleContext dbContext)
{
_peopleContext = dbContext;
}
public PeopleController(PeopleContext context, PeopleService service, ILogger <PeopleController> logger)
{
_context = context;
_service = service;
_logger = logger;
}
public PersonRepository(PeopleContext context)
{
_context = context;
}
public PeopleMiddleware(PeopleContext context)
{
db = context;
}
public PeopleRepository()
{
_db = new PeopleContext();
}
public PeopleService(PeopleContext context, IMapper mapper)
{
_context = context;
_mapper = mapper;
_logHelper = new LogHelper("PeopleService", new PeopleLogActionNameHandler());
}
public DbFactory(PeopleContext _dbContext)
{
this.dbContext = _dbContext;
}
public AddressesController(PeopleContext context)
{
_context = context;
}
public PeopleRepository(PeopleContext context)
{
this.db = context;
}
public IndexModel(ILogger <IndexModel> logger, PeopleContext peopleContext)
{
_logger = logger;
_peopleContext = peopleContext;
}
public SiblingsController(PeopleContext context)
{
_context = context;
}
public Handler(PeopleContext context, ILogger <List> logger)
{
_context = context;
_logger = logger;
}
public EFdbService(PeopleContext db)
{
this.db = db;
}
public Handler(PeopleContext context)
{
_context = context;
}
// SavedDataManager savedData;
public SavedController(PeopleContext _context)
{
this.context = _context;
// savedData = new SavedDataManager(this.context);
}
public PersonRepository(PeopleContext context)
{
_context = context;
}
public PeopleSeeder(PeopleContext ctx, IHostingEnvironment hosting)
{
_ctx = ctx;
_hosting = hosting;
}
public PersonRepository()
{
_context = new PeopleContext();
}
public void DeleteNotExistingEntities()
{
var p0 = new Person
{
FirstName = "Angelica",
LastName = "Tånneryd",
BirthDate = DateTime.Now
};
var p1 = new Person
{
FirstName = "Arvid",
LastName = "Tånneryd",
BirthDate = DateTime.Now,
Mother = p0
};
var p2 = new Person
{
FirstName = "Inga-Lill",
LastName = "Tånneryd",
BirthDate = DateTime.Now
};
var p3 = new Person
{
FirstName = "Linus",
LastName = "Tånneryd",
BirthDate = DateTime.Now,
Mother = p0
};
var p4 = new Person
{
FirstName = "Måns",
LastName = "Tånneryd",
BirthDate = DateTime.Now,
Mother = p2
};
var p5 = new Person
{
FirstName = "Viktor",
LastName = "Tånneryd",
BirthDate = DateTime.Now,
Mother = p0
};
using (var db = new PeopleContext())
{
db.People.AddRange(new[] { p0, p1, p2, p3, p4, p5 });
db.SaveChanges();
var people = db.People.OrderBy(p => p.FirstName).ToArray();
Assert.AreEqual(6, people.Length);
Assert.AreEqual(p0.Id, people[0].Id);
Assert.AreEqual(p1.Id, people[1].Id);
Assert.AreEqual(p2.Id, people[2].Id);
Assert.AreEqual(p3.Id, people[3].Id);
Assert.AreEqual(p4.Id, people[4].Id);
Assert.AreEqual(p5.Id, people[5].Id);
// Delete all children of p0 in the database
// that are not in the Items list.
db.BulkDeleteNotExisting <Person, Person>(new BulkDeleteRequest <Person>(
new [] { new SqlCondition {
ColumnName = "MotherId", ColumnValue = p0.Id
} },
new [] { "FirstName", "LastName" })
{
Items = new[] { p1, p3 }.ToList()
});
people = db.People.OrderBy(p => p.FirstName).ToArray();
Assert.AreEqual(5, people.Length);
Assert.AreEqual(p0.Id, people[0].Id);
Assert.AreEqual(p1.Id, people[1].Id);
Assert.AreEqual(p2.Id, people[2].Id);
Assert.AreEqual(p3.Id, people[3].Id);
Assert.AreEqual(p4.Id, people[4].Id);
}
}
public PeopleController(PeopleContext context, IPeopleService service)
{
_context = context;
_service = service;
}
public CustomersController(PeopleContext context)
{
_context = context;
}
public PeopleRepository(PeopleContext context, ILogger <PeopleRepository> logger)
{
_context = context;
_logger = logger;
}
public ValuesController(PeopleContext context)
{
_context = context;
}
public ActionResult Index()
{
PeopleContext db = new PeopleContext();
return(View(db.People.ToList()));
}
public IndexModel(ILogger <IndexModel> logger, PeopleContext db)
{
_logger = logger;
_db = db;
}
public ActionResult List()
{
PeopleContext db = new PeopleContext();
return(View());
}
public UnitOfWork(PeopleContext context)
{
this.context = context;
}
public MaterialRepository(PeopleContext context)
{
_context = context ?? throw new ArgumentNullException(nameof(context));
}
