3 TIER ARCHITECTURE IN ASP.NET MVC | DAL BAL

Hi, Currently I am learning ASP.NET MVC.. and I am going to tell us the way that how to implement 3 tier architecture in ASP.NET MVC using Class library.

I always use 3 tier architecture  in my projects.. So here in ASP.NET MVC I want to implement same 3 tier architecture . 

(I only describe about the DAL andPresentation layer,  you can yourself implement BAL)

This article purpose is to describe how you will create models in Data access layer (DAL) and access them in Presentation layer...

So lets start...

First open visual studio..(you must have MVC 3.0 installed) and create an new project.

Difference between a clustered Index and a Heap

A table that has no clustered index is referred to as a heap. Whereas a clustered index has the data stored logically in the order of the index key, a heap has no ordering of rows or pages.
When a row is added to a table with a clustered index, that row has a defined page that it must go on to

USE Class Library as a BLL, BO and DAL?

First read following article

Developing and Consuming Class Library in C#

Intro:- This is small article is base on class library. In this article I will tell you how use class library as a BLL,BO and DLL and how use them by add references.

First add an new project (asp.net web app.) 

Now add three solution folders as BLL, BO and DLL by right clicking on solution, you can see in the image.

now right click on the BO folder and follow the image

What is SOA (Service-Oriented Architecture)? Related to WCF and WWF?

By Shivprasad Koirala owner of Questpond.com
SOA (Service-Oriented Architecture)/Services and Messages :-
Services are nothing but the self contained business functionality. or you can say it is self contained business logic.

Here in the above image Counter, Kitchen and waiter are self contained business functionality(Service)

because they are in itself are complete we can use Kitchen with a 1 bed room set, or in a hotel we don't need any thing else with it. Its contain all its  functionality. same as waiter and Counter are also self contained business functionality(Service)

To implement SOA style of architecture here in .net we have WCF and WWF

How Create TextBox with Glow like Twitter Textboxes Using CSS3

CLICK HERE FOR READ COMPLETE ARTICLE

http://tutoriz.com/Thread-How-Create-TextBox-with-Glow-like-Twitter-Textboxes-Using-CSS3

Intro:-

Here in this article we will create twitter style textbox (glow) by using CSS3. Here we put the prient screens of every step from starting to end if you want to make it then you can take help of these images.

If facing any problem then put comment

1. This is twitter Textbox. Our goal is to give same look to our textbox.

HOW GET ID OF LAST INSERTED RECORD

Intro:- 

This small article is based on a situation where you need the ID of your latest inserted record.

means one every insert you want to get the ID of the inserted record by which you can know that record inserted successfully or not and can use its ID for other purpose. There are many way to achieve this. But here we will use output parameter

How encryption the connection strings in web.config?

Good Asp.net Interview question:-
How encryption the connection strings in web.config?
This can be achieved by using aspnet_regiis tool provided by the ASP.NET.
Click on the below link to read original article...
http://www.interviewcorner.com/answer/3608/Asp-Net-net-interview-question-does-encryption-of-connect

XML AUTO Use in SQL Server for Getting XML as a Result

How get Xml as a result set using select statement?
we can use For XML Auto Keyword
Lets Try

CASE KEYWORD EXAMPLE IN SQL INTERVIEW QUESTION

Can you write an query for displaying employee name and salary status like salary greater than 20000 or less then 20000 (not display salary only these string according to their salary)?
Lets try

Here we will use the Case Syntax 

I have written this article after reading Questpond article 
click here for read questpond article based on Case Syntax

other case example

Create Proc spGetEmployeesSorted
@SortCoumn nvarchar(10)
as
Begin

Select [Id],[Name],[Gender],[Salary],[City] 
From   [Employee]
Order by Case When @SortCoumn = 'Id' Then Id End,
                Case When @SortCoumn = 'Name' Then Name End,
                Case When @SortCoumn = 'Gender' Then Gender End,
                Case When @SortCoumn = 'Salary' Then Salary End,
                Case When @SortCoumn = 'City' Then City End
End

Insert Multiple Rows Using Single Insert Statement : SQLServer2008

How insert multiple record in a table using one insert statement in sqlserver 2008?


SQL server 2005 OLD way
insert into Companies select 'EnigmaSoft'
union all select 'WebCatalyst'
union all select 'Awarebase'


SQL server 2008 NEW way
insert into Companies values('HCL'),('Oracle'),('Infosys')

For more read SqlAuthority Article

Declare @i int = 1 | Diff between SQL Server 2005 and SQL Server 2008

One of the most famous interview question of SQL server is

"What is the diff. between Sqlserver 2005 and Sqlserver 2008"?

Here I am going to describe only 3 differences which is related to Declare and Set Keywords of Sql.

Differences 

1. You can declare variable and assign the value without using Set keyword in sqlserver 2008. / but not in 2005

2. You can increment the value like c# @i+=1 in sqlserver 2008. / but not in sqlserver 2005

3. You can put the break point for debug query  in sqlserver 2008. / but not in sqlserver 2005

...many other diff but here is only 3 we describing 

Declare @I int = 1

while(@I<=10)

begin

print @i

set @i+=1

end

Can you drop the database currently you working on? Interview questions

Hey first of all thanx for visit dotnetpoints.

One Impotent Sqlserver Interview Questions is

Can you drop the database currently you working on?

what is your answers?

yes or no?

Lets See:

Here we are going to try to drop the database with name "HH" and current we are using same "HH" database

we can't drop the database current we using. if you fire the drop query then you will got the following error message.

Msg 3702, Level 16, State 3, Line 1

Cannot drop database "YourDBName" because it is currently in use.

Now user other database and execute same query then see what happened

So the answer is No

PRIMARY KEY AND FOREIGN KEY RELATIONSHIP WITH QUERY

create table tbl_LaptopImages

(

iLaptopImageID int not null identity(1,1), iLaptopID int,

vchImageName nvarchar(200),bMainImage bit,

constraint LaptopImages_pk primary key(iLaptopImageID),

constraint fk_tblLaptops_tblLaptopImages foreign key(iLaptopID) references tbl_Laptops(ILaptopID)

)