Entity Framework Core Tutorial - Knowledge Base (KB)
168 results for: in tag: .net
Nuget can't resolve Entity Framework 7 dependency which is referenced in project
I'm currently developing a piece of software as coursework for a class and I've elected to make a Windows App and Windows Phone App. Being hit by the knowledge that Entity Framework 6 wasn't supported almost made me give up, but I started a complicated wo...
asked by Ashley Davies
How to make Package Manager Console in VS2013 available (not disabled)?
Currently, when I open Package Manager Console in VS2013 it is unavailable (all controls are in disabled state). I want to preform migrations in EF7. (EntityFramework.Commands packages from EF7 is installed in the project.)...I am not sure, why it is no l...
asked by TN.
Entity Framework 7 with ASP.NET 4.6
The question is quite simple: Is it possible to use ...Entity Framework 7... (beta4) with ...ASP.NET 4.6... (Web Api in my case)?...For the moment I cannot make it work, the following exception is always raised: ...An exception of type ...System.InvalidCa...
asked by Bidou
Get List of Modified Objects within Entity Framework 7
I am stumped - upgrading to Entity Framework 7 and I typically override the SaveChanges inside the ...DbContext... to be able to get a list of all the Modified Objects before it changes. Ultimately I have a script that fires that tracks the previous versi...
asked by kevin c
Show Original Values Entity Framework 7
I have an audit table that tracks Added, Deleted and Modified. I track this inside Entity Framework instead of using a Database trigger for multiple reasons but really because we use a Process Account and I want to track what user physically made that ch...
asked by kevin c
Get Entity Table Name - EF7
As the question states, anyone know how to get the entity table name in entity framework 7?...I have the code to do this in entity framework 6.1 (from another site, cant find link), but none of the interfaces/objects seem to be referenced in entity framew...
asked by Gillardo
UseSqlServer method missing MVC 6
I am trying to implement Entity Framework 7 in MVC 6, and on this page ...here... it says to do...services.AddEntityFramework() .AddSqlServer() .AddDbContext<MusicStoreContext>(options => options.UseSqlServer(Configuration[...
asked by Gillardo
How would you correctly return a collection of objects asynchronously?
I need to define methods in my core interface that return lists. My project heavily relies on the use of async/await so I need to define my core references/interfaces as asynchronous as possible. I also use EF7 for my data-access layer. I currently use ..
asked by Dealdiane
Table-per-Hierarchy inheritance in Entity Framework 7
I'm using Entity Framework beta 8 and Code First to work with SQLite Database....I need to have TPH inheritance, but by default it uses TPT inheritance....Here is a part of my code: ... public abstract partial class Amenity { [Key] public int Ame...
asked by Andrew Sklyar
Find a generic DbSet in a DbContext dynamically
I know this question has already been asked but I couldn't find an answer that satisfied me. What I am trying to do is to retrieve a particular ...DbSet<T>... based on its type's name....I have the following :...[assembly: System.Runtime.CompilerServices....
asked by DarkUrse
Entity Framework 7 FromSql stored procedure return value
I am trying to return a value using the new ...FromSql... command in Entity Framework 7. My stored procedure returns a value of 0 if all goes well and 1 if an error occurs. ...Using ...FromSql... with ...DbSet... we can for example do ..._dbContext.Exampl...
asked by luxury
Fetching items where nested collection contains item(s) form another collection
I'm trying to fetch item where it's nested collection contains item or multiple items from another collection. If I first enumerate the collection and then execute an in-memory ....Where()... filter, I get the expected collection....var filterTagIds = new...
asked by pootzko
Entity Framework Core (7): load single entity by id
.ToListAsync... is used to get a collection of items from DB in EF Core. That's clear. But what is the right way to get single item? In async way if possible....public async static Task<Source> LoadEntityAsync(int sourceID) { using (var db = new RPDBC...
asked by AsValeO
Defining a many-to-many relationship referencing the same table (EF7/core)
The model has ...item... entities. And there will be items that are dependent on (...using...) other items. Many-to-many relationship. Example:...Item A is used by Item B, C, and F. Item B is used by Item C, F and H. ...How one would correctly define dir...
asked by Meta
How to implement typesafe enum pattern in entity framework core rc2
How can I implement the ...typesafe enum pattern... in entity framework core rc2?...public class TestStatus { [Column("Id")] public int Id { get; private set; } [Column("Description")] public string Description { get; private set; } ...
asked by Eric Scott
Cannot update identity column 'Index'. EF Core
Like the title says, I'm getting a error message while I try to update a entity in EF Core. ...Here's the entity that I'm trying to update. Pay attention to the Index property tha's decorated with the Databasegenerated attribute. ...I tried to decorate wt...
asked by dont_trust_me
Package Remotion.Linq 2.0.2 is not compatible with netcoreapp1.0
This one is driving me crazy....If I create a .NET Core Console App in VS2015, making no changes it builds and runs as expected....When I add Entity Framework RC2 by adding a dependency in project.json...{ "version": "1.0.0-*", "buildOptions": { "...
asked by Mark Chidlow
Showing classes from indirectly referenced packages in .NET Core
I am trying to implement basic UoW/Repository pattern with ASP.NET/Entity Framework Core and I have encountered very troubling behavior....My solution consists of 4 projects in total.....DAL project..., where my entity classes are defined and where my DbC...
asked by Admir Tuzović
EF Core: Argument type is not assignable to parameter
I have some inheritance chain which start from interface and endsup with actual implmenetation going a couple of steps....However, this code is 100% correct...IBaseModel model = new ErrorModel(); ...But when I'm trying something like that:...class MyConte...
asked by silent_coder
Exception when trying to use `ThenInclude` in EF Core
I'm using ...Entity Framework Core... together with Repository Pattern and I'm having one issue....I have classes ...Customer..., ...Company... and ...Email... which, hiding things not relevant here, look like the following:...public class Email { pub...
asked by user1620696
Page 1 of 9