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();
}
