Good books on ADO.Net

I frequently get emails asking suggestion on good books on ADO.Net.
Here are few good books on ADO.Net for your reference.

1.  Microsoft ADO.NET 4 Step by Step (Step by Step (Microsoft)) 

2. Murach's ADO.NET 4 Database Programming with C# 2010 
(Murach: Training & Reference) 

3. ADO.NET 3.5 Cookbook (Cookbooks (O'Reilly)) 

4. A Programmer's Guide to ADO.NET in C sharp (Expert's Voice)

What is QueryString? What are the advantages and disadvantages of QueryString?

QueryString is a property of Request object in ASP.Net that provides a mechanism to send information to the server in the form of Sting in the URL.

Example: http://www.testsite.com/Webform1.aspx?fname=Alok&lname=Ranjan

In the above example, the destination webform name is Webform1.aspx and the information passed in QueryString is fname=Alok&lname=Ranjan. fname is a variable whose value is Alok, and similarly lname variable has value as Ranjan.

Advantages of QueryString:

• It's very easy to implement
• Every browser works with QueryString.
• It doesn't require server resources. Hence, doesn't put any burden on Server.

Disadvantages of QueryString:

• There is a limitation in the length of the QueryString as URL length has a limit. If you have to send lot of information, QueryString approach doesn't work.
• The information passed through QueryString is publicly visible. Hence, it poses security issue. So, QueryString can't be used while sending sensitive info. 
• QueryString can not be used to send & and space characters.

Dotnet Interview Questions for 1 year experience

Here are few basic dotnet interview questions asked in interview for a 1 year experience candidate.

About your project:

Get maximum knowledge about your current project. You should know the architecture diagram of your project. Also, you have to explain the Dataflow. You might be asked to tell what all dotnet new features used in your project.

Then follows technical discussion.

Dotnet Framework Interview Questions for 1 Year Experience:

1. What is CLR and it's functions?
2. How memory is managed in Dotnet applications?
Hint: Automatically by Garbage collector
3. What is an assembly?
4. What is a strong name?
5. What is MSIL?

C# Interview Questions for 1 Year Experience:

1. What are the 4 pillars of Object Oriented Programming?
2. What is a Class? What is an Object?
3. What is a partial class?
4. What is a sealed class?
5. What is constructor?
6. What is stringbuilder?

ADO.Net Interview Questions for 1 Year Experience:

1. What is connection string?
2. What is Datareader?
3. Difference between Dataset and datareader?
4. What is Ado.Net?
5. Namespace for using sqlserver database?

ASP.Net Interview Questions for 1 Year Experience:

1. What is web.config file and it's use?
2. What is global.asax?
3. What is session?
4. Which all controls you have used in your project?
5. What is gridview?
6. What is Authentication in ASP.Net and types of authentication?

SQL Server Interview Questions for 1 Year Experience:

1. What is Primary key, unique key and difference between them?
2. What is index? Types of index?
3. What is a stored procedure? Why it is better than inline query?
Hint: Stored Procedure is precompiles and has a execution plan. Hence faster execution.
4. You might be asked to write simple query
5. What is inner join

Also, if you know any advance concepts like WCF, WPF, LINQ, MVC, JQuerymention while telling "about yourself". You will be given preference. But, make sure you know the basics or worked on them for sometime.

Post questions you faced in interview in comments. Also post answers in comments to questions mentioned above.

What is the difference between web.config and machine.config

This is a common question asked in ASP.Net interviews.

Web.config and machine.config are two files used for managing configuration of web applications.

Machine.config:

1. The configurations mentioned in machine.config file are applicable to all the applications hosted in a machine/computer/server.

2. The machine.config file is located in x:\\Microsoft.NET\Framework\\config\machine.config

3. There can be only one machine.config file per machine (per dotnet framework installed).

web.config:

1. web.config file contains configurations for a single application.

2. Web.config files overrides the configurations mentioned in machine.config file.

3. The web configuration file is located in your application's root folder

4. There can be multiple web.config files in a single web application in different sub folders.

Learning/Academic projects in dotnet

I am writing this blog to share my mini Projects created for learning purpose. Also, these projects can guide you to create your Academic project in DOTNET for Computer Science or MCA courses.

I will post my original projects here. The projects will be in C#, dotnet, ASP.Net, ADO.Net, SQL Server, AJAX, JavaScript/VBScript, WebServices, WPF, WCF etc.

Please visit my blog regularly to get all the new projects posted.