What is Primary Key?

A Primary key is a column or a set of columns that can uniquely identify a row in a table. A table can have at most one primary key. A primary key have an implicit NOT NULL constraint. So, a column that is defined as the primary key cannot have NULL values in it.

Comments

Status code 415 unsupported media type in web api

In my application it was an issue because client was encoding the body content.But I was not specifying the encoding or media type. I have specified and resolved the issue as below var content = new StringContent ( postData , Encoding . UTF8 , "application/json" ); httpClient . PostAsync ( uri , content );

Set Sqlite to be case insensitive when string comparing?

We can use upper to make Sqlite Query case insensitive. SELECT * FROM TableName WHERE UPPER ( name ) = UPPER ( 'someone' )

Asp.net Component Model

ASP.Net Component Model: The ASP.Net component model provides various building blocks of ASP.Net pages. Basically it is an object model, which describes: · Server side counterparts of almost all HTML elements or tags, like <form> and <input>. · Server controls, which help in developing complex user-interface for example the Calendar control or the Gridview control. ASP.Net is a technology, which works on the .Net framework that contains all web-related functionalities. The .Net framework is made of an object-oriented hierarchy. An ASP.Net web application is made of pages. When a user requests an ASP.Net page, the IIS delegates the processing of the page to the ASP.Net runtime system. The ASP.Net runtime transforms the .aspx page into an instance of a class, which inherits from the base class Page of the .Net framework. Therefore, each ASP.Net page is an object and a...

DotNetRecipe

Search This Blog