public static void Seed()
{
var context = new IssuesContext();
var users = OutlookDataGenerator.Users
.Select(x =>
{
var split = x.Split(' ');
return(new User()
{
FirstName = split[0],
LastName = split[1]
});
})
.ToArray();
context.Users.AddRange(users);
context.SaveChanges();
var rnd = new Random(0);
var issues = Enumerable.Range(0, 1000)
.Select(i => new Issue()
{
Subject = OutlookDataGenerator.GetSubject(),
UserId = users[rnd.Next(users.Length)].Id,
Created = DateTime.Today.AddDays(-rnd.Next(30)),
Priority = OutlookDataGenerator.GetPriority(),
Votes = rnd.Next(100),
})
.ToArray();
context.Issues.AddRange(issues);
context.SaveChanges();
}
public MainWindow()
{
InitializeComponent();
var context = new EFCoreIssues.Issues.IssuesContext();
var source = new DevExpress.Data.Linq.EntityServerModeSource
{
KeyExpression = nameof(EFCoreIssues.Issues.Issue.Id),
QueryableSource = context.Issues.AsNoTracking()
};
grid.ItemsSource = source;
LoadLookupData();
}
public MainWindow()
{
InitializeComponent();
var source = new DevExpress.Data.Linq.EntityInstantFeedbackSource
{
KeyExpression = nameof(EFCoreIssues.Issues.Issue.Id)
};
source.GetQueryable += (sender, e) =>
{
var context = new EFCoreIssues.Issues.IssuesContext();
e.QueryableSource = context.Issues.AsNoTracking();
};
grid.ItemsSource = source;
LoadLookupData();
}
void LoadLookupData()
{
var context = new EFCoreIssues.Issues.IssuesContext();
usersLookup.ItemsSource = context.Users.Select(user => new { Id = user.Id, Name = user.FirstName + " " + user.LastName }).ToArray();
}
