Skip to main content

Elegant Data Access Strategies in .NET

Elegant Data Access Strategies in .NET

Thanks to ADO.NET, database access and management has never been easy and a breeze. We have high speed managed providers without much of resource consumption. All resource management are being managed by CLR.

The default support of database access in .NET is like

  1. SQLServer
  2. Oracle
  3. Generic OLEDB
  4. Generic ODBC

But it would be a better strategy for us to have a Data Access Layer, which is shortly known as DAL in programming world, which would have the complete onus in talking to the database and returning the results, instead of having each of our modules talk to the database.  This way, in future,if wanted to make some performance improvements to the database access, the changes are restricted to one particular area instead of having this spill out through out the application.

Perhaps, I would like to recommend to the readers, the following URLs which we researched upon in Database Access Layers. We also have our own GDN (GotDotNet) Workspace. If you are interested to contribute some effort, please do drop in.

  1. Full Database Abstraction Layer Generator by Jonathan De Halleux
  2. DotNetEmpire -- GotDotNET (GDN) Community Workspace by Vasudevan Deepak Kumar


Popular posts from this blog

Google NCR

Google NCRMost of you would be knowing about this trick in navigating to Google generic website. But I just came to know only a few days before and hence thought I would share the information with others too.
Whenever you type, Google automatically tries to redirect you to your country-specific website. For me, it always redirects to (Google India). But when we specifically want to navigate to Google Generic website for some reason, there are two ways to accomplish the same.Click the 'Go to' link at the bottom of the webpage that is displayed from prevent this redundant click, you can opt to type which would prevent the redirect from happening. The NCR stands for No Country Redirect. There is a brief discussion about this NCR over this forum.You may also like to check out Google help documentation regarding the country redirections from here.

Elegant 'MailTo' Replacement

Elegant 'MailTo' Replacement

MailTo tags have become a bane to all websites since spammers run spam robots which crawl the web to capture the email addresses, add to their catalogs and send spams to them. I just thought of sharing with others a simple JavaScript function which would trigger open the default email client instead of having mailto: embedded in the HTML Page.

Just have the following function included in your webpage

<script language='Javascript'>
function WriteMailTo(user,domain)
location.replace ('mailto:'+user+'@'+domain);

And whereever you want to invoke the mailto, just called WriteMailTo('user','') and the user's default email client should be launching (if configured) without any hassles.

Contacts import utility from Web2Project to Addressbook

I have been using Web2Project for planning my personal and professional tasks for a few years now. Now I have bifurcated the tools into the following:

Project PierAddress Book The only issue I had was to import my addressbook from Web2Project to AB. PP is a different animal. It does not serve as a comprehensive candidate for addressbook and hence I needed this bifurcation. 
I wrote up a following simple script to import the contacts to AB. The pre-requisite for this script is to hop on to PhpMyAdmin, export the contacts as a PHP array and then  modify the path in our import script to whatever you downloaded from PhpMyAdmin.
Our import script would explode the entries as SQL scripts into the browser window. Copy them and execute into PhpMyAdmin AB database to have the contacts imported.

Script URL: