Posts

Showing posts with the label stored procedure

A simple introduction to SQL+ Dot Net

Image
Explained  the SQL+.Net with a sample project and its steps.               SQL+.Net is the ORM for C# and SQL  designed to complement the skills of SQL developers. By simply adding comments to your SQL you can generate an object oriented class library with good performance. Here is the performance comparison by sqlservercentral.com          Dapper Insert 1000 Records:3364          EF Insert 1000 Records:12794          SQL Plus Insert 1000 Records:2316 Here I have created a console application with sample SQL+ .net ORM utilization. Prerequisites: Visual studio 2017/2019 SQL+.Net Extension – Download the extension in the link -  https://marketplace.visualstudio.com/items?itemName=AHHSoftware.SQLPlusCodeGenerationUtilityDotNetFrameworkVersion1 1. Create a database project Create a table Stored procedures for insert and select ...