public List <Employee> GetAllEmployees() { using (NorthwindModel model = new NorthwindModel()) { return(model.Employees.ToList()); } }
public SqlUnitOfWork(string connextionstringName) { var connectionString = ConfigurationManager.ConnectionStrings[connextionstringName].ConnectionString; _ctx = new NorthwindModel(connectionString); _ctx.Configuration.LazyLoadingEnabled = true; }
public void Update(Employee selectedEmployee) { using (NorthwindModel model = new NorthwindModel()) { model.Employees.AddOrUpdate(selectedEmployee); } }
public static ApplicationUserManager_V Create(IdentityFactoryOptions <ApplicationUserManager_V> options, IOwinContext context) { NorthwindModel db = context.Get <NorthwindModel>(); ApplicationUserManager_V manager = new ApplicationUserManager_V(new UserStore <ApplicationUser>(db)); return(manager); }
public static void Register(HttpConfiguration config) { config.MapODataServiceRoute( routeName: "ODataRoute", routePrefix: null, model: NorthwindModel.GetConventionModel()); var traceWriter = config.EnableSystemDiagnosticsTracing(); traceWriter.IsVerbose = true; traceWriter.MinimumLevel = TraceLevel.Debug; }
public static void Main(string[] args) { Console.WriteLine("Hello QueryInterceptor.EntityFrameworkCore"); Console.WriteLine("Enable ExpressionOptimizer"); ExtensibilityPoint.QueryOptimizer = ExpressionOptimizer.visit; var visitor = new EqualsToNotEqualsVisitor(); // doit IQueryable <int> query = Enumerable.Range(0, 10).AsQueryable().Where(n => n > 0 && n % 2 == 0); List <int> numbersEven = query.ToList(); Console.WriteLine("numbersEven > 0 = {0}", string.Join(", ", numbersEven)); List <int> numbersOdd = query.InterceptWith(visitor).Where(x => x >= 0).ToList(); Console.WriteLine("numbersOdd > 0 = {0}", string.Join(", ", numbersOdd)); var context = new NorthwindModel(); if (context.Database.EnsureCreated()) { context.Cars.Add(new Car { Brand = "Ford", Color = "Blue" }); context.Cars.Add(new Car { Brand = "Fiat", Color = "Red" }); context.Cars.Add(new Car { Brand = "Alfa", Color = "Black" }); context.SaveChanges(); } var carFirstOrDefault = context.Cars.AsQueryable().InterceptWith(visitor).Where(x => x.Color == "Blue").FirstOrDefault(); Console.WriteLine("carFirstOrDefault {0}", JsonConvert.SerializeObject(carFirstOrDefault, Formatting.Indented)); var carFirstOrDefaultAsync = context.Cars.AsQueryable().InterceptWith(visitor).Where(x => x.Color == "Blue").FirstOrDefaultAsync(); Console.WriteLine("carAsync {0}", JsonConvert.SerializeObject(carFirstOrDefaultAsync.Result, Formatting.Indented)); var carToListAsync = context.Cars.AsQueryable().InterceptWith(visitor).Where(x => x.Color == "Blue").ToListAsync(); Console.WriteLine("carToListAsync {0}", JsonConvert.SerializeObject(carToListAsync.Result, Formatting.Indented)); Console.WriteLine("Press key..."); Console.ReadLine(); }
static void Main(string[] args) { var visitor = EqualsToNotEqualsVisitorFactory.EqualsToNotEqualsVisitor; Console.WriteLine("Hello QueryInterceptor.Core.ConsoleApp.net452"); IQueryable <int> query = Enumerable.Range(0, 10).AsQueryable().Where(n => n > 0 && n % 2 == 0); List <int> numbersEven = query.ToList(); Console.WriteLine("numbersEven > 0 = {0}", string.Join(", ", numbersEven)); List <int> numbersOdd = query.InterceptWith(visitor).Where(x => x >= 0).ToList(); Console.WriteLine("numbersOdd > 0 = {0}", string.Join(", ", numbersOdd)); Console.WriteLine(new string('-', 80)); Console.WriteLine("Enable ExpressionOptimizer"); ExtensibilityPoint.QueryOptimizer = ExpressionOptimizer.visit; numbersEven = query.ToList(); Console.WriteLine("numbersEven > 0 = {0}", string.Join(", ", numbersEven)); numbersOdd = query.InterceptWith(visitor).Where(x => x >= 0).ToList(); Console.WriteLine("numbersOdd > 0 = {0}", string.Join(", ", numbersOdd)); var ctx = new NorthwindModel(); var carsAsyncToListAsync0 = ctx.Cars.Where(x => x.Color == "White").ToListAsync(); Console.WriteLine("carsAsyncToListAsync {0}", JsonConvert.SerializeObject(carsAsyncToListAsync0.Result, Formatting.Indented)); var carsAsyncToListAsync = ctx.Cars.InterceptWith(visitor).Where(x => x.Color == "White").ToListAsync(); Console.WriteLine("carsAsyncToListAsync InterceptWith {0}", JsonConvert.SerializeObject(carsAsyncToListAsync.Result, Formatting.Indented)); var carFirstOrDefault = ctx.Cars.InterceptWith(visitor).Where(x => x.Color == "White").FirstOrDefault(); Console.WriteLine("carFirstOrDefault InterceptWith {0}", JsonConvert.SerializeObject(carFirstOrDefault, Formatting.Indented)); var carFirstOrDefaultAsync = ctx.Cars.InterceptWith(visitor).Where(x => x.Color == "White").FirstOrDefaultAsync(); Console.WriteLine("carFirstOrDefaultAsync InterceptWith {0}", JsonConvert.SerializeObject(carFirstOrDefaultAsync.Result, Formatting.Indented)); Console.WriteLine("Press key..."); Console.ReadLine(); }
public IActionResult Northwind01() { using (var dbc = new NorthwindModel()) { //--SELECT CustomerID, CompanyName, Address, City, Region, PostalCode, Country //--FROM Customers //--WHERE LOWER(City) = 'paris' OR LOWER(City) = 'london' var customers = dbc.Customers.Where(c => c.City.ToLower().Contains("paris") || c.City.ToLower().Contains("london")).ToList(); ViewBag.Customers = customers; } return(View()); }
public static void Register(HttpConfiguration config) { // enabling querying options config.Select().Expand().Filter().OrderBy().MaxTop(null).Count(); config.MapODataServiceRoute( routeName: "ODataRoute", routePrefix: null, model: NorthwindModel.GetConventionModel()); var traceWriter = config.EnableSystemDiagnosticsTracing(); traceWriter.IsVerbose = true; traceWriter.MinimumLevel = TraceLevel.Debug; }
public async Task <ActionResult> Register(Register login_) { if (ModelState.IsValid) { DbLevel NW = new DbLevel(); Employees empl = NW.GetEmployee(login_); ApplicationUser user = new ApplicationUser() { UserName = login_.Email, FirstName = login_.FirstName, LastName = login_.LastName }; NorthwindModel db = new NorthwindModel(); if (empl != null) { IdentityResult result = await UserManager.CreateAsync(user, login_.Password); if (result.Succeeded) { login_.Message = empl.FirstName + @" your account created. Login with your credentials"; TempData["Message"] = login_.Message; TempData["EmployeeID"] = empl.EmployeeID; return(RedirectToAction("Login", "Validation")); } if (result.Errors != null && result.Errors.Count() != 0) { //String buillder ommitted for simplicity. foreach (string error_ in (from s in result.Errors select s)) { login_.Message += " " + error_; } TempData["Message"] = login_.Message; return(RedirectToAction("Register", "Validation")); } } else { TempData["Message"] = @"Employee not found. Are you working here?"; login_.Message = TempData["Message"] as string; } } return(View(login_)); }
public IndexModel() { NorthwindModel = new NorthwindModel(); }
public Repository() { model = new NorthwindModel(); }
public HomeController(NorthwindModel northwindModel) { _northwindModel = northwindModel; }
public EmployeeRepository() { model = new NorthwindModel(); }
public OrderDetailRepository() { model = new NorthwindModel(); }