ASP.NET Web API using SQL Server

In this article, I am going to discuss ASP.NET Web API using SQL Server database. So here we will create the Web API Service which will perform the CRUD operation on the SQL Server database. We are going to use this service as the base for...

Read More

Cascading referential integrity constraint in Sql Server

Hi friends! In our previous sessions we have seen how to create tables and enforce primary and foreign key constraints between them. And in our last session we learnt adding a default constraint in SQL Server. Now, Today we are going...

Read More

Default constraint in Sql Server

Hi friends! In our last session we learned how to create tables (tblPerson and tblGender) and we made a relation between them using foreign key constraints. This is the structure of the previous tables that we have worked on. In this post,...

Read More

Creating and Working with tables in Sql Server

Hi friends! In our last post we have seen How to create Database and perform Alter, Delete/ Drop operation on databases in SQL Server. Today, We are going to learn how to create a Tables in SQL Server and implementing Foreign Key Constraint...

Read More