If you want to develop a modern web application, you will realize very quickly that you can’t write everything on your own. You will rely on some third party client and server side libraries and components to increase your development speed. There are many online code repositories and sources available to developers these days and downloading and keeping track of all third-party packages can be a painful task
When defining models for use with the Entity Framework (EF), developers often include all of the classes to be used throughout the entire application. This might be a result of creating a new Database First model in the EF Designer and selecting all available tables and views from the database. For those of you using Code First to define your model, it might mean creating DbSet properties in a single DbContext for all of your classes or even unknowingly including classes that are related to those you’ve targeted.
There are situations where you might receive this error message “Transaction count after EXECUTE indicates a mismatching number of BEGIN and COMMIT statements. Previous count = 0, current count = 1.”. Even when using a TRY CATCH block in the stored procedure and a ROLLBACK in the catch block, this error still occurs. One reason this is not captured is because fatal errors are not caught and the transaction remains open. In this tip we will look at how you can handle this issue.
Open DOS prompt as administrator and navigate to downloaded files MS DOS vs_sql.exe –layout C:\Business\Trash\SSDT\OfflineFiles –lang en-us
If there is error in download, type the command below to fix the error: (only do this if you also had download errors) ;
vs_SQL.exe –layout C:\SSDT2017 –fix
Navigate to the directory where you downloaded the layout files (in my case, C:\Business\Trash\SSDT\OfflineFiles) vs_setup.exe –NoWeb
There’s not much to change here, just click on the Install button (or maybe change the installation path):
Once installation is done, we will be able to see a minimal version of VS2017. Now we can install SQL Server Data Tools 2017 (SSDT) through the normal installer (SSDT-Setup-ENU.exe), remembering to check the SSIS, SSRS and SSAS options: SSDT-Setup-ENU
Once the installatin is successful, make sure the SQL Server project templates (Database Project / SQLCLR), Analysis Services (SSAS), Integration Services (SSIS) and Reporting Services (SSRS) are working normally.