MSBuild.Sdk.SqlProj
qest
Our great sponsors
| MSBuild.Sdk.SqlProj | qest | |
|---|---|---|
| 5 | 4 | |
| 373 | 9 | |
| 2.1% | - | |
| 8.3 | 0.0 | |
| 12 days ago | over 1 year 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.
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?
qest
-
do you support putting business logic in SQL server while building applications using .net6 and dapper and er core
Actually, you can version control the schema! Just store your sql script for entity creation in git, and deploy with dacpacs and sqlpackage. As for the tests, I'll do a little bit of self promotion here: https://github.com/Geims83/qest (feedback is welcome)
-
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 :)
-
sql testing tool
So, after some thinking, I made this: Geims83/qest: A simple, cross platform, command line tool to test MSSQL procedures (github.com) As the description goes, it's a (.net) command line tool to test procedures call by defining test files in yaml format.
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.
vstest - Visual Studio Test Platform is the runner and engine that powers test explorer and vstest.console.
QuartzNet - Quartz Enterprise Scheduler .NET
movie-search-application - 🎬 A simple movie search app, built with .Net 7, Vertical Slice Architecture and using TMDB APIs and YouTube APIs for searching and details of the movies.
Mond - A scripting language for .NET Core
DBConfirm - A C# testing framework to write and run tests for logic within SQL Server.
Bridge.NET - :spades: C# to JavaScript compiler. Write modern mobile and web apps in C#. Run anywhere with Bridge.NET.
Onion-architecture-ASP.NET-Core - WhiteApp API solution template which is built on Onion Architecture with all essential feature using .NET 5!
Flyway - Flyway by Redgate • Database Migrations Made Easy.
my-db-container