C# Tutorial

.

Introduction of C# By: Munesh Sharma In This tutorial we will see Introduction of C# Continue Reading...
Reading and writing to a console in C# By: Munesh Sharma Here we will learn how to Reading and writing to a console in C# Continue Reading...
Nullable Types in C# By: Munesh Sharma In This tutorial we will see what is Nullable Types in C# Continue Reading...
Datatype conversions in C# By: Munesh Sharma Here we will learn about Datatype conversions in C# Continue Reading...
Arrays in C# By: Munesh Sharma In This tutorial we will see Arrays in C# Continue Reading...
Type of Comment in C# By: Munesh Sharma Here we will learn about type of Comment in C# Continue Reading...
If statement in C# By: Munesh Sharma In This tutorial we will see If statement in C# Continue Reading...
switch statement in C# By: Munesh Sharma Here we will learn about switch statement in C# Continue Reading...
Loop in C# By: Munesh Sharma In This tutorial we will see Loop in C# Continue Reading...
Foreach loop in C# By: Munesh Sharma Here we will learn about Foreach loop in C# Continue Reading...
Method in C# By: Munesh Sharma In This tutorial we will see Method in C# Continue Reading...
Method Parameters in C# By: Munesh Sharma Here we will learn about Method Parameters in C# Continue Reading...
Difference between Types and Type Members in C# By: Munesh Sharma In This tutorial we will see Difference between Types and Type Members in C# Continue Reading...
Access modifier in C# By: Munesh Sharma Here we will learn about Access modifier in C# Continue Reading...
Namespace in C# By: Munesh Sharma In This tutorial we will see Namespace in C# Continue Reading...
Delegate in C# By: Munesh Sharma Here we will learn about Delegate in C# Continue Reading...
Inheritance in C# By: Munesh Sharma In This tutorial we will see Inheritance in C# Continue Reading...
Polymorphism in C# By: Munesh Sharma Here we will learn about Polymorphism in C# Continue Reading...
Enums in C# By: Munesh Sharma In This tutorial we will see Enums in C# Continue Reading...
Struct in C# By: Munesh Sharma Here we will learn about Struct in C# Continue Reading...
Exception Handling in C# By: Munesh Sharma In This tutorial we will see Exception Handling in C# Continue Reading...
Properties in C# By: Munesh Sharma Here we will learn about Properties in C# Continue Reading...

Introduction of C#

                                                                                                                                      Previous....... 
                                                                                                                                                    Next.......

C# is case sensitive language.
In this Part

1. We will learn the basic structure of a c# program. The program we used in this video is shown below.

// Namespace Declaration

using System;


class NetQube

{

    public static void Main()

    {

        // Write to console

        Console.WriteLine ("Welcome to NetQube Technologies!"); 

    }

}

2. Understand the purpose of using System declaration - The namespace declaration,using System, indicates that you are using the System namespace. If  you omit theusing System, declaration, then you have to use the fully qualified name of the Consoleclass. A namespace is used to organize your code and is collection of classes, interfaces, structs, enums and delegates. We will discuss about namespaces in detail in a later session.
3. Purpose of Main() method - Main method is the entry point into your application.


                                                                                                                                       Previous....... 
                                                                                                                                                    Next.......

Dot Net Tutorial

Here i will explain all the tutorial as a chapter. I will explain from basic to end with examples and i will give practical Knowledge.

Previously I have explained about SQL SERVER, Asp.Net, Ado.Net .
Here i will explain for those  I have created this tutorial to help those in need.If you find this useful then please share it with your friends on Facebook and Google plus. 
If anyone face problem regarding these tutorial then leave a comment.

1. C#
2. Asp.net
3. Ado.net
4. SQL Server
5. Windows Form
6. EntityFrameWork Tutorial
7. Asp.Net MVC Tutorials
8. GridView Tutorials
9. Angular JS Tutorials

What is deferred name resolution in SQL Server

Let me explain deferred name resolution with an example. Consider the stored procedure shown below.

Create procedure spGetCustomers
as
Begin
Select * from Customers1
End

Customers1 table does not exist. When you execute the above SQL code, the stored procedure spGetCustomers will be successfully created without errors. But when you try to call or execute the stored procedure using Execute spGetCustomers, you will get a run time error stating Invalid object name 'Customers1'.

So, at the time of creating stored procedures, only the syntax of the sql code is checked. The objects used in the stored procedure are not checked for their existence. Only when we try to run the procedure, the existence of the objects is checked. So, the process of postponing, the checking of physical existence of the objects until runtime, is called as deffered name resolution in SQL server.

Functions in sql server does not support deferred name resolution. If you try to create an inline table valued function as shown below, we get an error stating Invalid object name 'Customers1' at the time of creation of the function itself.

Create function fnGetCustomers()
returns table
as
return Select * from Customers1

So, this proves that, stored procedures support deferred name resolution, where as functions does not. Infact, this is one of the major difference between functions and stored procedures in sql server.