Showing posts with the label C#Show all

Saving picture to Database in c#

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 …

Read more

SqlQuery in EF Core (EntityFrameworkCore) without DbSet

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…

Read more

Creating SQL CLR Assembly in C#

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 …

Read more

Ajax form in asp.net MVC core 3.1

Ajax form in asp.net MVC core 3.1 In this article we will how to insert record in database using Ajax Form in asp.net core. Create new asp.net core mvc project Enable migrations Create dbContext class Create Stored Procedure Create Inte…

Read more