Evolve
DbUp
Our great sponsors
Evolve | DbUp | |
---|---|---|
5 | 10 | |
822 | 2,083 | |
- | 0.8% | |
3.6 | 8.5 | |
3 months ago | about 1 month ago | |
C# | C# | |
MIT License | MIT License |
Stars - the number of stars that a project has on GitHub. Growth - month over month growth in stars.
Activity is a relative number indicating how actively a project is being developed. Recent commits have higher weight than older ones.
For example, an activity of 9.0 indicates that a project is amongst the top 10% of the most actively developed projects that we are tracking.
Evolve
-
How to Handle MSSQL Database in CI/CD?
If you want to stay in C# land, look at Evolve.
-
Can I export database from PostgreSQL and connect it to my C# app?
So, in general, one would use a versioned database schema that would connect to a database and execute a series of SQL files. For C# you have things like Evolve.
-
The correct way to source control data
So you don't really source control the data, but you do source control the database schema. A common way in the .net world to do this is to use something like evolve which basically allows you to version SQL scripts and have them executed on application launch.
-
Best db migration tool options to use along with Entity Framework
Been using https://github.com/lecaillon/Evolve for many years. Its a .Net Core equivalent to Flyway. You run plain old SQL scripts and just follow a file naming convention. It can run embedded inside a project, it has a .Net Tool and a standalone CLI. The SQL scripts can also be embedded in the executable or as external files.
-
Developing with SQL Server in .NET
I've been using Evolve in the past, very simple and effective.
DbUp
- How to Handle MSSQL Database in CI/CD?
-
create table in SqlDataProvider
I am not super familiar with SqlDataProvider, but its generally purpose is to interact with the DB at runtime, and not to migrate sql databases. I would probably use some ddl migration tool like DbUp, https://github.com/DbUp/DbUp, to handle table creation.
- Dev ,production best way to migrate migrations
- How do you do CI/CD with ef core
-
Best db migration tool options to use along with Entity Framework
I've used a simple migration tool called DbUp https://github.com/DbUp/DbUp
- Is it sensible to run EF migrations at startup?
-
Have to use SQL Server 2005 to pull data into a web application
Yea - it usually takes some diligence to maintain sprocs in a nice way. When my teams have used dapper in a production environment/application we usually combine it with something like dbup which lets us source control all of the objects/up/down scripts. It's like EF migrations but works with simple scripts.
-
Automate Manual SQL runs
Check out DbUp This is what we use and created a custom app that gets invoked within our pipeline
What are some alternatives?
Entity Framework - EF Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations.
FluentMigrator - Fluent migrations framework for .NET
roundhouse - RoundhousE is a Database Migration Utility for .NET using sql files and versioning based on source control
yuniql - Free and open source schema versioning and database migration made natively with .NET/6. NEW THIS MAY 2022! v1.3.15 released!
Versioning.NET - A dotnet tool that automatically increments versions in csproj files based on git commit hints.
AutoTrimps - AutoTrimps - Zek
sqlancer - Automated testing to find logic and performance bugs in database systems
Unfold - Powershell-based deployment solution for .net web applications
key-value-store - Basic Key-Value Store built on top of YugabyteDB, .Net 7.0, and Entity Framework Core 7.0.
Octo Pack - Creates Octopus-compatible NuGet packages