Is putting business logic in stored procedure a good Idea?

This page summarizes the projects mentioned and recommended in the original post on /r/dotnet
msbuild-sdk Mssql sqlproj unit-testing Dacpac

InfluxDB
Our great sponsors
  • InfluxDB - Power Real-Time Data Analytics at Scale
  • WorkOS - The modern identity platform for B2B SaaS
  • SaaSHub - Software Alternatives and Reviews
Our great sponsors

  • qest

    A simple, cross platform, command line tool to test MSSQL procedures

    • 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 :)

  • MSBuild.Sdk.SqlProj

    An MSBuild SDK that provides similar functionality to SQL Server Data Tools (.sqlproj) projects

    • 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 :)

  • InfluxDB

    Power Real-Time Data Analytics at Scale. Get real-time insights from all types of time series data with InfluxDB. Ingest, query, and analyze billions of data points in real-time with unbounded cardinality.

    InfluxDB logo

  • DBConfirm

    A C# testing framework to write and run tests for logic within SQL Server.

    • You can also write unit tests for SQL using C#: https://github.com/Bungalow64/DBConfirm

NOTE: The number of mentions on this list indicates mentions on common posts plus user suggested alternatives. Hence, a higher number means a more popular project.

Suggest a related project

Related posts