MS SQL Server | SHASHANGKA SHEKHAR'S BLOG

Learn About MEAN Stack

Mar 5, 2018 Posted by Shashangka Shekhar AngularJS, JavaScript, NodeJS, Stored Procedure, T-SQL 0 comments

MongoDB, Express, AngularJS, Node.js abbreviated as MEAN, these are development pack by all Javascript. In this sample we are going to use MSSQL Server instead of MongoDb.

With this application sample we can create a new user, show all the user, modify user data & also can able to delete the user through API build with Express from frontend using AngularJS.

Components:

MSSql – SQL database
Express – NodeJS Framework
Angular – JavaScript frameworks for Frontend
NodeJS – JavaScript Execution environment (Server)

User Specific Notifications Using ASP.NET MVC & SignalR

Dec 30, 2017 Posted by Shashangka Shekhar .Net, AJAX, ASP.NET, Entity Framework (EF), IIS, MS SQL Server, SignalR, Visual Studio, Web API 6 comments

In this post we are going to explore how to implement user based notification using ASP.Net MVC & SignalR.

In case if you are new to SignalR the please get some basics here: https://docs.microsoft.com/en-us/aspnet/signalr/overview/getting-started/introduction-to-signalr

Why SignalR?

SignalR provides “real-time” web functionality in our application using Javascript function call in client browser from server (Server Sent Events). It has several connection management like

connect/disconnect/reconnect events,
grouping connections,
authorization etc

Go to http://signalr.net for more. Read More

Modify Database State Using User-defined Function

Nov 20, 2017 Posted by Shashangka Shekhar .Net, MS SQL Server, T-SQL 0 comments

In this post we are going to Insert data using an UDF. We all know that User-defined functions (UDF) cannot be used to perform actions that modify the database state.

Error Occur while Inserting using UDF:

Invalid use of the side-affecting operator ‘INSERT’ within a function.

Scaffolding ASP.Net Core MVC

Dec 9, 2016 Posted by Shashangka Shekhar .Net, .NET Core, Entity Framework (EF) 0 comments

In this post we are going to explore how to create model based on existing database (Db-First), with the help of Entityframework Core Command then learn how to generate Controller & Views using Scaffolding (Interface & Code-Generator Command) based on model.
Read More

.Net Core Code First Migration using Class Library

Aug 30, 2016 Posted by Shashangka Shekhar .Net, .NET Core, Entity Framework (EF), MVC 5 comments

In this post we are going to elaborate how to work with EF code first migration using .Net core class library.

Pages:‹123 4 5 ›