Difference between private assembly and shared assembly

Title:What is the difference between private and shared assembly

Description:This is question we are getting whenever attended to interview .Below are some of the differences
1.In private assembly all the referred DLL's will be copied into global project debug folder but in shared assembly will not.
2.Private assemblies are faster in accessing,when compare with shared assemblies
3.Memory wise shared assembly are recommended.
4.The private assembly is used when only one project need to be developed for a client but shared assembly is used when more then one project Need to be developed

Difference between sqlserver 2008 and sqlserver 2012

Title: Difference between SQL Server 2008 and SQL server 2012

In previous articles i explained sqlserver 2008 concepts like Delete duplicate rows/columns from table,
Sql server 2012:
1.The SQL Server 2012 uses 48 bit precision for spatial
2.In SQL server 2012 has unlimited concurrent connections
3.By default it supports 15,000 partitions
4.Available new string functions CONCATE and FORMAT
5.Available new conversion  functions are PARSE ,TRY_CONVERT,TRY_PARSE
6.Microsoft.SqlServer.Dac and Microsoft.SqlServer.Dac.Extensions are introduced to perform  operations on Packages

Sql server 2008:
1.Maximum number concurrent connections to SQL Server 2008 is 32767
2.The SQL Server 2008 uses 27 bit precision for spatial
3.It can support only 1000 partitions
4.The CONCATE and FORMAT not available
5.Not available conversion function which are mentioned in SQL 2012

Difference between ADO and ADO.NET

Title:Difference between ADO and ADO.net

Below are some of the differences between ado.net and ado

ADO:
1.ADO are implemented using com technology
2.In the ADO we can store only one table in record set
3.Ado's doesn't support data relations
4.Ado's is not front end RDBMS
5.Ado's are connection oriented database management system
6.Using Ado's we can't integrate with XML
7.Using Ado's we can't generate sql statements
8.Ado,s are doesn't support data transactions

ADO.NET
1.ADO.NET are implemented using .net framework technology
2.In the ADO.NET we can store multiple tables in record set
3.Ado.NET support data relations
4.Ado.NET is not front end RDBMS
5.Ado.NET are connectionless oriented database management system
6.Using Ado.NET we can integrate with XML
7.Using Ado.NET we can generate sql statements
8.Ado.NET support data transactions

Difference between value type and reference type data types in c#

Title: What is difference between Value and Reference type in C#.net

Description:While using  the c#.net we have to know some basic concepts such as data types.Now i would like to describe the features and difference of data types
Value Type:
1.Value type holds the data directly
2.value type doesn't contain default value
3.Value type should be in STACK memory at compile time
4.STACK is not accessible with Garbage collection(GC)
5.Example for value types:Structures,Enums etc
Reference Type:
1.Reference type holds the address but not data
2.Reference type holds the default value
3.Reference type will be stored in HEAP memory at run time
4.HEAP memory is accessible with GC
5.Example for Reference type:Classes,objects,arrays.Interfaces etc

Difference between Read(),Readline() and ReadKey in C#

Title:Difference between Read(),Readline() and ReadKey in C#

Description:
These methods can be used to read the values from the console and done some specific functionality on it.Each of the property is used to return the different values .The declaration of  static methods in console application as below

Read()        :accept the string value and return the string value.
Readline() :Accept the string and return Integer
ReadKey() : Accept the character and return Character


Declaration In Application:

Console.Read();
Console.Readline();
Console.ReadKey();

If we use Read line or Read() we need press Enter button to come back to code.If we using Read key() we can press any key to come back code in application