Entity Framework Core Tutorial - Knowledge Base (KB)
2016 results for: in tag: c#
Conditionally Include and ThenInclude
As commonly known in EF-Core there is no Lazy loading. So that kind of means I'm forced to do my queries with some afterthought. So since I have to think, then i might as well try to do it properly....I have a Fairly standard update query, but I thought h...
asked by Thomas Andreè Lian
Many-to-many query in Entity Framework 7
I am following this example which I got from ...http://ef.readthedocs.org/en/latest/modeling/relationships.html...class MyContext : DbContext { public DbSet<Post> Posts { get; set; } public DbSet<Tag> Tags { get; set; } protected override voi...
asked by Wheel Builder
Entity Framework 7 : Generating Invalid Column Name
using EF 7 : 1.0.0-rc1-final,...I'm having trouble with EF generating the query properly, using database first approach - using ef scaffolding to to generate some model properties listed in the DbContext - as the tables contain a large number of columns I...
asked by Danish
How to use injected DbContext in parallel methods in asp.net core and ef7?
I have an Asp.net 5/Core 1 application with EF7. I register the DbContext in the DI container normally....services.AddEntityFramework().AddSqlServer() .AddDbContext<MyDbContext>(options => options.UseSqlServer(connection)); ...Here is a small sample sho...
asked by MathiasR
How to efficiently work with Entity Framework Core?
Let's take a look at simple class examples:...public class Book { [Key] public string BookId { get; set; } public List<BookPage> Pages { get; set; } public string Text { get; set; } } public class BookPage { [Key] public string B...
asked by Yurii N.
Setting journal mode in SQLite for Entity Framework Core code-first
I'm using DBContext on Entity Framework, using a process like ...in this tutorial... to create the DB....public class BloggingContext : DbContext { public DbSet<Blog> Blogs { get; set; } protected override void OnConfiguring(DbContextOptionsBuild...
asked by Tyress
Entity Framework 7 Invalid Column Name
I'm creating EF7 mappings for an existing database and I'm getting an "Invalid column name" error. The code that is throwing the error is:...public class DepositContext : DbContext { public DbSet<tblBatch> Batches { get; set; } public DbSet<tblTr...
asked by Jeff Hornby
Mapping One-to-Zero-or-One with EF7
I am currently in the process of cleaning up a fairly large database. Part of the database has a relationship which is a one-to-zero-or-one mapping. Specifically:...User -> UserSettings ...Not all users will have user settings, but a user setting cannot e...
asked by JasCav
UseSqlServer is not defined in DbContextOptionBuilder
I am trying to configure entity framework 7 in my console application....However , I noticed that "UseSqlServer" is not defined in DbContextOptionBuilder...Here is the code...public class LetsBreakITContext : DbContext { public DbSet<Book> Boo...
asked by Alan B
How do I change connectionstring at runtime in EF7 Core?
I am building system where each customer will have it's own database. When a customer loggs in, I will use the domain name of the users email adress to decide what connectionstring it should use....Today, the connectionstring is set in the startup.cs file...
asked by Per B
DbContext timeout while running linq query
I have the following async method that queries for some data on a database....private async Task<List<MyObject>> GetTotalConcert(DateTime d1, DateTime d2, string[] name) { using (RegistrationDbContext context = new RegistrationDbContex...
asked by user3587624
Getting many-to-many objects populated with Entity Framework 7
I have the following Many-To-Many relationship setup illustrated here by a database diagram: ...These are represented by the following POCO classes, from which the database was created using Entity Framework code first:...public class ExerciseCategory { ...
asked by Wheel Builder
ChangeTracker.Entries() CurrentValue equals OriginalValue in EF7
I have a issue in EF7/asp.Net Core application. In my context I create a method Save:... public int Save() { ChangeTracker.DetectChanges(); var modifiedEntities = ChangeTracker.Entries() .Where(p => p.State == EntityStat...
asked by Cezary Rynkowski
When Entity Framework 7.0 will be released?
I want to know the exact date the Entity Framework 7.0 will be released? Also, Will be a performance difference between EF6.0 and EF 7.0
asked by yo2011
Entity Framework 7 Rollback method
How to roll back an transaction in Entity Framework 7?...In the old version, we have... try { dataContext.ChangeTracker.DetectChanges(); dataContext.SaveChanges(); } catch (Exc...
asked by user1108948
Entity Framework 7 - run seed at the end of the migration
I have a migration class:...public partial class TestMigration : Migration { protected override void Up(MigrationBuilder db) { ...At the end of the Up method, I would like to add some data (seed). MigrationBuilder exposes some methods, also Sql(),...
asked by MadDeveloper
How to persist a list of strings with Entity Framework Core?
Let us suppose that we have one class which looks like the following:...public class Entity { public IList<string> SomeListOfValues { get; set; } // Other code } ...Now, suppose we want to persist this using EF Core Code First and that we are usi...
asked by user1620696
Migrations in EF Core RC2
When I try to add migration I get:...This preview of Entity Framework tools does not support targeting class library projects in ASP.NET Core and .NET Core applications. See ...http://go.microsoft.com/fwlink/?LinkId=798221... for details and workarounds..
asked by mneu
EF7 Migrations - The corresponding CLR type for entity type '' is not instantiable
I'm trying to use EF7 migrations and got stuck when I modelled a Organization model with inheritance....Organization is a abstract class and there is two concrete classes that inherit it called Individual and Company....I set the Organization abstract cla...
asked by Rovdjuret
How to implement the field decimal(5,2) in EntityFrameworkCore 1.0 rc2?
How to implement the field ...decimal(5,2)... in ...EntityFrameworkCore 1.0 rc2... ?...HasPrecision... seems to be not available anymore?
asked by Caesar
Page 1 of 101