How to implement Entity Framework Core 3.1.2 with Firebird database using 'database first approach'

.net .net-core c# entity-framework-core firebird

Question

I am currently developing a .NET Core 3.1 Web API which should communicate with a Firebird database (storing/retrieving data). I would like to handle that communication using Microsoft.EntityFrameworkCore 3.1.2. Entity Framework is completely new for me so excuse me if this question is too simple. But I couldn't find the answer online.

Because the database is really big I want to automatically generate all my needed models using EF Core.

I tried using the Scaffold-DbContext command in the packet manager console:

Scaffold-DbContext "user id=USER;password=PASSWORD;database=DATABASE;data source=SOURCE;port number=PORT;character set=UNICODE_FSS;pooling=False;server type=Default" FirebirdSql.EntityFrameworkCore.Firebird -OutputDir Models

Entity Framework Core is generating the Context.cs but not any models.

Do I have to specify the models I want to import? How do I do that?

1
2
4/10/2020 10:44:58 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

To summarize the response to the question you posted on the firebird-net-provider group, support for scaffolding the model in EntityFrameworkCore is currently not available for Firebird. The improvement ticket for this is DNET-798.

2
3/4/2020 5:17:14 PM

Related Questions

Share connection between DbContext objects in Entity Framework 6 Database first approach

I am trying to share a connection in between 2 different DB context objects using EF 6 . I have got the code mentioned here ...https://msdn.microsoft.com/en-us/data/dn456843.aspx... to work for a single DB Context but as soon as I try to share the connection with another DB Context object I am running into trouble. Below is what I have done so f...
c# entity-framework entity-framework-6
asked by Pratik

Entity Framework 6 Database First Approach Not Creating All Tables From SQL Server

When I create a model using the "Database First" approach in my ASP.NET MVC 5 project, not all my tables from SQL Server are created in my project....I've followed everything in this article step by step: ...https://www.asp.net/mvc/overview/getting-started/database-first-development/creating-the-web-application...ASP.NET MVC Project Model:...SQL Se...
asp.net-mvc asp.net-mvc-5 entity-framework entity-framework-6 sql-server
asked by SJCypher

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 TestingContext(DbContextOptions<TestingContext> options) : base(options) { ...
asp.net-core dbcontext entity-framework-core
asked by user2320476

Entity Framework Core Database First - Multiple Foreign keys to one table

Background Information...I am currently working with EF Core using a database first implementation....Current tables...Fizz { [Id] INT [Category] varchar [Value] varchar } Buzz { [Id] UniqueIdentifier [TypeId1] INT [TypeId2] INT CONSTRAINT [FK_Buzz_Fizz_1] FOREIGN KEY ([TypeId1] REFERENCES [Fizz][Id]) CONSTRAINT [F...
asp.net-core-2.0 c# ef-database-first entity-framework-core
asked by Leustherin

Add child entities to database and assign them to parent object in database Entity Framework Core

I have a datamodel named "Document" which looks like this:...public class Document { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Id { get; set; } //[ForeignKey("Id")] public List<DocumentLine> Lines { get; set; } public DateTime PurchaseDate { get; set; } public double TotalValue { get; set; } } ...It...
c# entity-framework-core xamarin.forms
asked by N.iw

Entity framework Core - Ambiguity over choosing Code First Approach and Database First Approach

Choosing the Code First approach or the Database First approach with ...Entity Framework Core... for my case is looking confusing from best approach point of view....I have an existing database with some complex stored procedures. ...If I choose the Database First approach, will it be good from performance point of view?...If I choose the Code Firs...
ef-code-first ef-database-first entity-framework-core
asked by Malatesh Patil

What is the difference between EF Core Database-First and EF Core Code-First approaches?

I was wondering... since there is no EDMX in EF Core, what is the difference between those 2? And if the major difference would be the possibility to change the database tables, why not use code first then use EF code-first migrations?
asp.net-core ef-code-first ef-database-first entity-framework-core
asked by shade1337

Adding Database Model (Database First Approach) in .NET Core class Library

I am adding Data Model (Database First Approach) in .NET Core Class Library using Entity FrameWorkCore....I have added all necessary packages and when I try to create the model using below command using PMC I am receiving below message:..."No project was found. Change the current working directory or use the --project option."...Command in PMC (usi...
.net-core-class-library asp.net-core entity-framework-core
asked by user3861578

Create Database Views using EF Core Code First approach

I am working on a new application that requires, the creation of DB Views. I am using EF core with MySql flavor and using the Code First approach to create the DB and tables. I didn't find a way to create a view though.If somehow, I could execute the raw sql in migration step, that might help in creation of view and later mapping that as the DbSet....
entity-framework entity-framework-core
asked by Abhishek Singh

With Entity Framework Core database first approach how do I separate my entity from infrastructure layer?

I'm building REST APIs with ASP.NET Core and Entity Framework Core with a database-first approach with clean architecture. ...My database is already created and maintained by a DBA team - that's why I need to use Entity Framework Core with a database-first approach, and we need to do reverse engineering using the ...Scaffold-DbContext... command in...
asp.net-core-webapi c# clean-architecture entity-framework-core
asked by Amit Kashyap

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow