Convert data access layers SQL Server

My new project involves data access layers needing to be converted into SQL Server tables.

Can someone explain a data access layer and how I would convert into SQL Server tables?
LVL 1
IdaracAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PortletPaulfreelancerCommented:
"data access layer" is a generic term
A data access layer (DAL) in computer software, is a layer of a computer program which provides simplified access to data stored in persistent storage
http://en.wikipedia.org/wiki/Data_access_layer

In general these allow other 'layers' of an application to use 'persistent storage' using methods that remain consistent. The DAL itself then deals with details that are specific to the type of persistent storage, e.g. a DAL may be designed to allow support for multiple RDBMS vendors such as Oracle and SQL Server. This "abstraction" of data storage specifics also helps separate business logic from the data model allowing changes in a data model that won't directly impact the business logic.

e.g.
Building a Multi-Tier Web Application in the .NET 3.5 Framework Using LINQ to SQL
http://www.codeproject.com/Articles/22069/Building-a-Multi-Tier-Web-Application-in-the-NET-3
Tutorial 1: Creating a Data Access Layer
http://msdn.microsoft.com/en-us/library/aa581778.aspx


>>and how I would convert into SQL Server tables?
from what?
using what? (java?, perl? .net? php? ... )

i.e. more information/background would be useful.
0
IdaracAuthor Commented:
All I have been told is to convert 10 data access layers into SQL Server tables.

Does that make any sense to you?
0
PortletPaulfreelancerCommented:
yes & no

I understand the concept (the yes)

but cannot advise further without knowing more about the existing DALs (the no)

e.g.
is it java?
is it .net?

is the existing data persistence using a relational dbms?
(e.g. it could be XML right now)

For example, I regularly deal with apps that support both Oracle and MS SQL Server
here, the DALs basically involve finding mssql equivalents to items built using Oracle

it might be as simple as changing
NVL(x,0)

to
ISNULL(x,0)

or it may be re-writing entire complex stored procedures/triggers

the aim is to provide "exactly the same" functionality from each change of dbms platform both in terms of inputs and outputs

does this help?
0
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

IdaracAuthor Commented:
I just heard it will VB.Net
0
PortletPaulfreelancerCommented:
and the existing DALs use what for the dbms?
bit surprising that vb.net DALs need conversion to sql server

anyway,  vb.net isn't one of my life experiences, so I can't give you much insight on that front.
0
IdaracAuthor Commented:
I don't know if it is using a relational dbms assuming maybe Access or Oracle.

I think I am getting it. I am still learning .Net but I think I see where DAL can be useful.

Putting all your logic into a separate area where the rest of the app can access it. So that all data access is inside the DAL. For example business logic should not contain any data access and should call on the DAL for any data retrieval.

See if this look s right....

If the business layer wants to Know the address of a certain client it would make a call to the DAL GetClientAddress("Joe Blow"). If there are any data changes then we would modify the method GetClientAddress in the DAL (if changes were required) without having to touch the rest of the app.
Without the DAL the Business logic would have to do something like "Select Address from Clients where Name = 'Joe Blow'. Then if there are data changes we would have to search the entire Business logic to see where changes would have to be made.

So given my project I am going to assume that either the app has 10 DAL setup for the the app OR there are 10 methods or areas of change in the DAL that have to be addressed. Or maybe he has 10 apps that need the DAL changed.
0
PortletPaulfreelancerCommented:
>>See if this look s right....
looking very right; by George you have it!

I'd vote " Or maybe he has 10 apps that need the DAL changed."
Looks like you may have some work ahead of you - not a bad thing!

best of Luck as always!
Cheers, Paul
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
IdaracAuthor Commented:
Thank U for your help
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server

From novice to tech pro — start learning today.