MSBuild.Sdk.SqlProj
DBConfirm
Our great sponsors
MSBuild.Sdk.SqlProj | DBConfirm | |
---|---|---|
5 | 1 | |
373 | 5 | |
2.1% | - | |
8.2 | 3.7 | |
6 days ago | 4 days ago | |
C# | C# | |
MIT License | Apache License 2.0 |
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.
MSBuild.Sdk.SqlProj
-
Is putting business logic in stored procedure a good Idea?
On the other hand, logic in the database is difficult to test and to keep in source control. For the testing part, I've created https://github.com/Geims83/qest :) For the source control, I like to use https://github.com/rr-wfm/MSBuild.Sdk.SqlProj and text files :)
-
How do you use git on sql server?
We use this https://github.com/rr-wfm/MSBuild.Sdk.SqlProj so we can build dacpacs with the dotnet cli tool.
- Rodando a SUA estrutura de banco de dados em um container!
-
Version Control Stored Procedures
For the deployment just create a dacpac (with sql projects or other sdks like this one https://github.com/rr-wfm/MSBuild.Sdk.SqlProj and then publish with sqlpackage or dotnet publish
- How to handle long SQL commands?
DBConfirm
-
Is putting business logic in stored procedure a good Idea?
You can also write unit tests for SQL using C#: https://github.com/Bungalow64/DBConfirm
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.
qest - A simple, cross platform, command line tool to test MSSQL procedures
QuartzNet - Quartz Enterprise Scheduler .NET
EnvironmentDetector - Library that provides a simple way to detect whether your code is running in a test environment or not. It currently supports detecting MSTest, NUnit, and xUnit test frameworks.
Mond - A scripting language for .NET Core
SpecFlow - #1 .NET BDD Framework. SpecFlow automates your testing & works with your existing code. Find Bugs before they happen. Behavior Driven Development helps developers, testers, and business representatives to get a better understanding of their collaboration
Bridge.NET - :spades: C# to JavaScript compiler. Write modern mobile and web apps in C#. Run anywhere with Bridge.NET.
Flyway - Flyway by Redgate • Database Migrations Made Easy.
my-db-container