I am about to begin a new project which will target an existing database with some existing tables with data. As part of my project, i will create some new tables and make relation ships with the existing tables ? Which approach is better in this scenario. I believe code first will be a problem because i don't want to loose my data every time when i make a change to the table structure (for my new table).
What is the best approach to create new tables in existing db with data?
300 Views Asked by Happy At
1
There are 1 best solutions below
Related Questions in .NET
- file download method in visual studio 2017
- Repository manager receives the wrong connection string in .net core
- MongoDb not connecting C#
- The current .NET SDK does not support targeting .NET Core 6.0. Brand new WPF Project VS Community 2022 17.9.5
- Why Scanning GSI on DynamoDb doesnt work as fast as expected when using CONTAINS?
- Are "blittable types" really unmanaged types for StructLayout Sequential
- Failed to fetch dynamically imported module on Blazor JS Interop
- Problem to upload several images per one request
- Implementing Azure AD B2C Authentication in .NET 8 Blazor Project (RenderMode: InteractiveAuto)
- Stripe connect payout - throws exceptions
- 'IOException: The cloud file provider is not running', when trying to delete 'cloud' folder
- Azure Application Insights Not Displaying Custom Logs for Azure Functions with .NET 8
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Socket.io nodejs server .NET connection
- Producer Batching Service Bus Vs Kafka
Related Questions in ENTITY-FRAMEWORK
- Query (or LINQ in Entity Framework) for getting user's rank
- I'm trying to create a user with identity in .NET 8 with Entity Framework and I'm getting the following error, both in MySQL and SQL Server
- Entity Framework, Error when deleting data from multiple tables at the same time
- The instance of entity type 'User' cannot be tracked because another instance with the same key value for is already being tracked. Not structural
- Is it a good idea to use EF with Supabase?
- ModelState.IsValid is false when its Data Model Concurrency Token is non nullable
- EF6 Find function always go to the DB
- A second operation started on this context before a previous operation completed. in .NET Core
- Internal .NET Framework Data Provider error 1 in EF
- why cannot dotnet ef tools find my installed dotnet sdk and runtime
- Blazor hybrid cant add migration
- Access to all types, classes and interfaces from multiple projects through reflection in C#
- how to Store/Map Complex data type using EF?
- The database operation was expected to affect 1 row(s), on UpdateAsync
- Is it possible to generate database-agnostic migrations with Entity Framework?
Related Questions in EF-CODE-FIRST
- Having trouble with EF Core / ASP.NET Core MVC MultiSelectList selectedItems
- EF Core database-first: proper workflow
- HasComputedColumnSql() method not working as Expected
- Different tool to generate codefirst migration. Time to clean up and refactor
- I want to save the report to the SQl Server database automatically from the DevExpress report designer interface
- Why won't EF Core migration tools add column collation?
- How can I access Entity Type information in EF Core with code first?
- Error In create constraint or index on asp.net
- Introducing foreign key constraint may cause cycles or multiple cascade paths - How do I specify "ON DELETE NO ACTION"?
- Entity Framework Core - One-to-one relationships not creating foreign key
- Entity Framework code-first, Null entries being written to database
- .NET EF Core Sort by child collection property
- How to force Entity Framework 6 to drop/create table instead of renaming?
- Dependency loop despite entities configuration in Entity Framework. Include vs Join
- Saving parent and children into separate tables with EF Core
Related Questions in EF-DATABASE-FIRST
- EF Core database-first: proper workflow
- Visual Studio 2022 connection to Teradata ODBC Driver 17.10 from Server Explorer
- how to prevent entity framework to change column names of just one of tables?
- How do I map foreign keys in Entity Framework Core to an existing database?
- EF How can I update my Database with Migrations
- Replace EF Core Default Schema in xUnit
- Entity Framework losing connection data after creation
- How I can use an already existing table in SQL Server with ApplicationDbContext.cs
- Entity Framework Core database-first approach
- The type or namespace name 'Employee' could not be found in Entity Framework
- How to ignore a column by default in EF Core in the base entity and but still be able to fetch it in a class that derives from the base entity
- How can I provide subquery for expanding navigation properties
- Generate a class based on a database query
- data type 'bit' is not supported for Entity Framework version using postgresql
- Entity Framework Core set nullable prop only if default is true
Related Questions in EF-MODEL-FIRST
- The 'Claims' property on the 'Customer' type is not a navigation property
- EF Core 6 is generating duplicate foreign keys on base type and inherited types when scripting the dbcontext
- Is there any package or tool exposing the function to build EF EDMX models from database?
- Computed column based on rows from another table
- Storing a attribute with JSON value in CosmosDB using Entity Framework Core 3
- Nested comments ef core table model returns all comments?
- EFCore Model is invalid. Reference another class from it multiple ways seems to be the problem?
- Model first approach, default value of property is not generated in the SQL script
- Entity Framework query table with different name
- Entity Framework Optimistic Concurrency exception with DateTime
- EF6 - which file based database
- I want to Add multiple Roles at the time of registeration with many to many relationship using EF Models in MVC
- Model-First approach options in Python ORMs(and Code-First)
- Pass null datetime using EF model-first
- Entity Framework model first: create UNIQUE constraint programmatically
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Model-first would be the easier solution. You would just create a model from the database and then you will update the database from the model after adding new entities.
You can achieve the same result with code-first too, but with a little extra work. You will need to use EF Migrations to add the new tables to your database. You can read more about EF Migrations here and here.