Entity Framework Core Tutorial - Knowledge Base (KB)
52 results for: in tag: dbcontext
EF7: DBContext configuration on ASP.NET 5 Web-API
I'm currently developing an ASP.NET 5 Web-API application with VS2015 Ultimate Preview. Some things have changed about configuring EF7 on this new platform....I've already checked the help in this page: ...https://github.com/aspnet/EntityFramework/wiki...
asked by NetCito
Dependancy Injected DbContext is empty after populating DbContext created with new (EF7, ASP.NET 5, vnext)
I am relatively new to EF7 and have heard that Dependency Injection of DbContexts into the Controller constructor is a good way to go about getting the DbContext for use within given Action methods. However, there are many situations where Dependency Inje...
asked by Ryan
How do you configure the DbContext when creating Migrations in Entity Framework Core?
Is there way that dependency injection can be configured/bootstrapped when using Entity Framework's migration commands?...Entity Framework Core supports dependency injection for ...DbContext... subclasses. This mechanism includes allowing for configurati...
asked by vossad01
ASP.NET 5, Entity Framework 7 & SQL Server 2014 - multiple dbContexts, SQL views
I have created a solution in Visual Studio 2015 consisting of a Web project (using the ASP.NET 5 Beta 6 Web Application Preview Template), and a Model project (using Entity Framework 7 Beta 6)....I got to the point where I could get data from a SQL Server...
asked by Jerms
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
Entity Framework Core 1.0 DbContext not scoped to http request
I understood by watching this video with Rowan Miller ...https://channel9.msdn.com/Series/Whats-New-with-ASPNET-5/06...(at minute 22)... that the way of configuring Entity Framework Core (previously known as EF7) into an ASP.NET Core 1.0 app (previously k...
asked by iberodev
'Microsoft.EntityFrameworkCore.Infrastructure.IDbContextFactory`1[TContext]' violates the constraint of type parameter 'TContext'
It's my first time using asp 5\core1 and i'm having problem setting a entity framework dbcontext...I have one class library with my object...public class Utilizador { public Utilizador() { } public int id { get; set; ...
asked by Shakawkaw
Entity Framework Core DbContext and Dependency Injection
I'm building a service application using Web API, .Net Core and EntityFramework Core....For configuring options in my DbContext I'm using these lines in "ConfigureServices" method in Startup.cs... var connection = @"Server=ISSQLDEV;Database=EventManagemen...
asked by Pouyan
Entity Framework Core - Mapping Raw Query(DTO Class without ID field) , Scalar
I am using EFCore with ASPNETCore, everything looks great, but I find these two situations:...I have created a DTO classes that are not tables in the database, these classes that will map a raw SQL query or procedure....So I need to map the results of an ...
asked by Jose Eduardo Poma Caceres
How to include related entities in an Entity Framework Core 1.0.1 raw query?
Setup:...ASP .NET Core 1 Web API...MySQL Server Community Edition 5.7...Entity Framework Core 1.0.1 with Pomelo MySQL driver (3 separate contexts, 3 separate databases)....Contexts: MainContext (maindb), Module1Context (module1db), Module2Context (module2...
asked by Alin Florin
Create a new DbContext or use the injected DbContext when calling a stored procedure in Entity Core?
What is the proper way to execute a stored procedure (using the ADO method) in Entity Core?...Should I use the injected dbcontext or should I create a new one?...public class ContactController { private readonly MyDbContext _context; public Cont...
asked by johnluke.laue
IdentityServer4 with a customise ConfigurationDBContext
Is it Okay if I customise the ConfigurationDBContext? I have already created one, the code is below...public class MyConfigurationDbContext : ConfigurationDbContext { public MyConfigurationDbContext(DbContextOptions<ConfigurationDbContext> opt...
asked by MJK
DotNet Core , No database provider has been configured for this DbContext
I want to select data from my table "Header" using a simple LINQ command but I faced error....My Action... public HeaderModel GetHeaderInformation() { using(var context = new ApplicationDbContext()) { var header = contex...
asked by Arash
Avoid Entity Framework Error with Multiple Tasks Running Concurrently on Same DbContext
I have a WebApi controller in a Dotnet Core project running Entity Framework Core with Sqlite....This code in an action occationally produces errors:...var t1 = _dbContext.Awesome.FirstOrDefaultAsync(a => [...]); var t2 = _dbContext.Bazinga.FirstOrDefault...
asked by Oskar Lindberg
Net Core - .Include() results in loop causing Visual Studio debug to crash
My database has a one-to-many relation between "UsageRecord" and "Dimension" ...This is modelled as follows (using a Database-First approach):...public partial class Dimension { ... public virtual ICollection<U...
asked by alessalessio
Entity Framework Core Using multiple DbContexts
I'm having a problem that when I try to access a field in my PartsDbContext I get the following error: ...System.Data.SqlClient.SqlException: 'Invalid object name 'fieldName''...It seems that this is because I'm trying to make my PartsDbContext use the sa...
asked by Joe Higley
Pass multiple connection strings through IServicesCollection.AddScoped<T>()
.net core webapi application with entityframeworkcore. Trying to figure out how to pass an additional connection string into the data access library class in addition to the dbcontext. See ** dbcontext ** below is what I want to do....startup.cs... ...
asked by user2503078
Creating a database context using the database first approach with entityframework core.
I want to be able to create a database context with entityframework core in my webapi project using the database first approach. When I create like this it works very well... public class TestingContext : DbContext { public TestingC...
asked by user2320476
Error CS1061 'DbContextOptionsBuilder' does not contain a definition for 'UseMySql'
I just learn to use ASP.NET CORE 2.0 MVC using Visual Studio Community Edition. I want to use MySQL database instead of using SQL Server because I need to use some data inside the old MySQL DB. Please help me solving this problem .. thank you...Here is my...
asked by nightingale2k1
Is it possible to use one database to dynamically define the ConnectionString of another?
I've reached a bit of a brick-wall with my current project....I have three normalised databases, one of which I want to dynamically connect to; these are:...Accounts: For secure account information, spanning clients...Configuration: For managing our clien...
asked by derpasaurus
Page 1 of 3