Solved

Dynamic Connection Strings in Microsoft Enterprise Library 3.1

Posted on 2007-11-25
4
1,320 Views
Last Modified: 2013-11-26
I'm a complete beginner when it comes to .NET coding. I've been tasked to write a C# database class for the basic connect, dataset, datareader etc functions. It's going to replace existing VB code, so needs to be available to both WIndows apps and Excel VBA.

I've come across the Ent Lib and while it provides most of the functionaility, I like may others can't find a way to use the Database Factory with a dynamic connection string. My boss likes the functionality it provides, but wants to see another layer of encapsulation on top - i.e. a simple connect(connString) to connect to a db.

Is it worth looking at Ent Lib for this purpose or am I better off starting from scratch? Can anyone provide a wrapper that encapsulates the functionality I need?
0
Comment
Question by:da_h
  • 2
  • 2
4 Comments
 
LVL 21

Expert Comment

by:MogalManic
ID: 20349340
You could write a simple method that parses the connection string for the provider attribute and then return the proper connection object.  Maybe something like this:
static public IDbConnection CreateConnection(string ConnectionString) 
{
 if (ConnectionString==null || ConnectionString.Length==0)
   throw new Exception("Unknown or undefined datasource name");
 
 string[] ConnectionAttributes=ConnectionString.Split(';'); 
 string NewConnectionString="";
 foreach (string s in ConnectionAttributes) {
   string[] AttributeParts=s.Split('=');
   string attributeName=AttributeParts[0].ToLower().Trim();
   if (attributeName=="provider") 
   {
     string provider=AttributeParts[1].ToLower();
     if (provider == "system.data.sqlclient")
     {
        return new SqlConnection(connectionString);
     } 
     else if (provider == "system.data.oledb")
     {
        return new OleDbConnection(connectionString);
     }
     else if (provider == "system.data.oracleclient")
     {
        return new OracleConnection(connectionString);
     }
   }
   throw new Exception("Missing 'provider' attribute in connection string");
}

Open in new window

0
 

Author Comment

by:da_h
ID: 20393467
Thanks Mogal....sorry for the slow reply, I've been interstate.

Although this is along the lines of what I'm looking for. Ideally what I'd like to know is if there is a somewhat complete database class / wrapper that you tend to use as the basis of a database dependent project, i.e something that handles opening, closing, stored procs, querying etc that can then be customised to suit the projects needs.

I'm not looking for someone to write the complete class for me but would assume that a relatively complete (and hopefully well coded) example exists out there somewhere.





0
 
LVL 21

Accepted Solution

by:
MogalManic earned 500 total points
ID: 20394937
Sorry,

Most of the code I write is proprietary or uses a database mapping tool called IBATIS (http://ibatis.apache.org/).

I did a quick search of Code project and found the following:
  - http://www.codeproject.com/cs/database/Multi-Tier.asp - looks like a wrapper around the DataTable class
  - http://www.codeproject.com/cs/database/CustomCommandBuilder.asp - Typed dataset wrapper
  - http://www.codeproject.com/cs/database/MpmCodeproject.asp - Wrapper for open source Mimer (http://developer.mimer.com/mpm/)
  - http://www.codeproject.com/cs/database/persistedobject.asp - Generic persistance wrapper
  - http://www.codeproject.com/vb/net/data_access_layer.asp - THIN ADO.net wrapper (written in vb.net)
  - http://www.codeproject.com/cs/database/SimpleQuery.asp - Simple query methods (needs support for parameters added)

You can take samples from the above and build your framework.
0
 

Author Closing Comment

by:da_h
ID: 31410926
Thanks

I've since found a couple of good examples to get me going. Some of your links have helped fill in the gaps.
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Batch file or script with password 22 61
Footer for each row on Gridview 2 32
Upgrading my SSIS package in VS 2012 6 58
Need syntax help building hyperlink 2 20
More often than not, we developers are confronted with a need: a need to make some kind of magic happen via code. Whether it is for a client, for the boss, or for our own personal projects, the need must be satisfied. Most of the time, the Framework…
This article aims to explain the working of CircularLogArchiver. This tool was designed to solve the buildup of log file in cases where systems do not support circular logging or where circular logging is not enabled
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used.

789 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question