asp.net tips and tricks

Saving image to Database in c# saving picture to database is simple task. For saving images in database we have to convert image to byte array. And for reading we will reverse this process i-e we will convert back byte arrary to image. lets start by creating new …

Executing SqlQuery in Entity Framework Core without DbSet Create asp.core MVC api project Add the required packages to project Add DbContext Class Add Extension methods Add Interface (IDepartmentService) to project Add Class (DepartmentService) and…

Create CLR Assembly in C# SQL CLR SQL CLR or SQLCLR (SQL Common Language Runtime) is technology for hosting of the Microsoft .NET common language runtime engine within SQL Server. The SQLCLR allows managed code to be hosted by, and run in, the Microsoft …

split string function (table valued function) in sql server   1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 CREATE FUNCTION [dbo].[fn_split]( @ pCommaSeparatedString VARCHAR ( 8000 ), @ pDelimiter CHAR ( 1 ))…