qest
DBConfirm
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.
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.
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?
vstest - Visual Studio Test Platform is the runner and engine that powers test explorer and vstest.console.
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.
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.
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
MSBuild.Sdk.SqlProj - An MSBuild SDK that provides similar functionality to SQL Server Data Tools (.sqlproj) projects
Onion-architecture-ASP.NET-Core - WhiteApp API solution template which is built on Onion Architecture with all essential feature using .NET 5!