Solved

Dynamic Connection Strings in Microsoft Enterprise Library 3.1

Posted on 2007-11-25
4
1,307 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

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Today I had a very interesting conundrum that had to get solved quickly. Needless to say, it wasn't resolved quickly because when we needed it we were very rushed, but as soon as the conference call was over and I took a step back I saw the correct …
Calculating holidays and working days is a function that is often needed yet it is not one found within the Framework. This article presents one approach to building a working-day calculator for use in .NET.
Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

707 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now