<div>
<div class="content wysiwyg-content">
Hi All,<br />
<br />
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.<br />
<br />
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?<br />
<br />
Many thanks,<br />
<br />
Rit
</div>
</div>


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

ASP.NET Deveopment with MS Access Queries or hardcode?

The successor to Active Server Pages, ASP.NET websites utilize the .NET framework to produce dynamic, data and content-driven web applications and services. ASP.NET code can be written using any .NET supported language. As of 2009, ASP.NET can also apply the Model-View-Controller (MVC) pattern to web applications

ASP.NET

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.