Resetting the Primary Key of a Table

-

This quick tip will show how to reset the primary key values for a table in SQL Server:


DBCC CHECKIDENT ([Table], RESEED, [NewCurrentValue])

Where [Table] is the table name and [NewCurrentValue] is the new current value of the id. This would ideally be set to 0, so that the next value (when a row is inserted) will be 1.

Popular posts from this blog

Vertical Slices Application Design with MediatR: Part 2

-
Image
This is the second post of my two-part series about designing applications using vertical slices and how the open-source library MediatR can facilitate this design. In the first post we talked about the vertical slices design and how it addresses some of the problems in traditional database table-centric designs. In this post we will see how we can implement a vertical slices design using the open source library MediatR. Put on your programmer hat as we'll dive into some code!
Read more

Deploying a Web Application to Local IIS using Visual Studio 2017

-
Image
In this post we are going to see how to deploy a web application on your development machine. The end goal is to have a web application running on the development machine outside of the context of Visual Studio and which is accessible to other devices on a local network. Install IIS Before we get started, we need to make sure that IIS is installed on our machine. Here are the steps to do that in Windows 10: Open the search dialog by pressing WinKey + S or by clicking the magnifying glass icon. Type in "Turn Windows features on or off" and click on the matching result. You'll see the "Windows Features" window (see sample image below), which has a list of folders with checkboxes beside them. Look for the folder "Internet Information Services" and make sure that the checkbox is filled with either a check or a black square. If it is, you're good to go. If the checkbox is empty, check it and click OK. Windows will install IIS for you. ...
Read more

Login with AngularJS and ASP.NET Web API

-
Image
When creating a non-Web API ASP.NET MVC project using Individual Accounts, the generated template makes use of Forms Authentication. When logging in using Forms Authentication, a cookie is stored on the client's machine and that cookie is included by the browser in each future request.
Read more