• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 277
  • Last Modified:

ASP.NET Deveopment with MS Access Queries or hardcode?

Hi All,

Now if I had a SQL Server database I would naturally build a bunch of stored procedures to process my data requirements as I believe there is a performance benefit.

As I have to use MS Access on this particular project, is there any real benefit executing MS Access Queries rather than storing thehardcoded SQL statements within my data access layer classes?

Many thanks,

Rit
0
rito1
Asked:
rito1
1 Solution
 
AndyAinscowFreelance programmer / ConsultantCommented:
Performance - as far as I know there will be no advantage (or disadvantage) to using Access queries.

Design - the query designer in Access is very comfortable to use (I prefer it to SQL Server's design window) and being able to see a visual map of the query it is easier to understand than a lot of text.
0
 
rito1Author Commented:
Excellent thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now