471,582 Members | 1,344 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,582 software developers and data experts.

2 Question about Enterprise Library 2.0

Well, I guess I did express myself very clearly.

I implemented the Ent Lib 2.0 data block against SQL database
successfully. The system now is a production system. But now we want to
migrate the database to MySQL. From mySQL website you can find
Connector/Net 1.0 and COnnector/ODBC, further more this link talks
aboout
http://dev.mysql.com/tech-resources/...x.html#ADO.NET
different approaches to connect to mySQL.
My question is which one should I use so that my coding change is
minimum. I guess if I use ODBC then what I need to change is the
connectionstring in my web.config file. But ODBC may not be the best
choice since it is slow? For Connector/Net1.0 I am not sure wether Ent
Lib 2.0 support it or not.
My second question is how can I encrypt the connectionstring in my
web.config file to protect user credential and at the same time the ENt
Lib 2.0 can use the decrypted connectionstring. (where should I decrypt
the connectionstring?)

Sorry for the confusing first post

Thanks again
-rockdale

Jan 9 '07 #1
1 1452

You want to avoid the ODBC if you can. It introduces more layers, something
affecting performance.

The big scoop with ODBC (circa late 1990's) was that it allowed a common
syntax between different vendors.
But, you paid the price for this generic-ness.

However, you have a bigger question.

Has someone extended the 2.0 Enterprise Library for use with MySql? I don't
know the answer to this.

http://www.aspfree.com/c/a/ASP.NET/C...ing-ASPNET-20/

a.. Database (the abstract class)
a.. SqlDatabase
a.. OracleDatabase
a.. GenericDatabase
You see, someone has created a "concrete" class for Sql Server, called
SqlDatabase.
Someone has created a concrete class for Oracle, called OracleDatabase

the question is... has someone out there in internet-land wrote one for
MySql.
as in, they wrote a concrete class (which works specifically with MySql)
which implements:
Microsoft.Practices.EnterpriseLibrary.Data.Databas e

Or can you use the GenericDatabase object?

I'm not a MySql person, so I don't know the answers.

Your post:
http://dev.mysql.com/tech-resources/...x.html#ADO.NET

This articles shows how to talk to MySql thru DotNet, this is not an
extension of the EnterpriseLibrary (for MySql)

Try here
http://www.codeproject.com/useritems...th_Ent_Lib.asp

which I found by googling:
"Microsoft.Practices.EnterpriseLibrary.Data" MySql
"rockdale" <ro************@gmail.comwrote in message
news:11*********************@p59g2000hsd.googlegro ups.com...
Well, I guess I did express myself very clearly.

I implemented the Ent Lib 2.0 data block against SQL database
successfully. The system now is a production system. But now we want to
migrate the database to MySQL. From mySQL website you can find
Connector/Net 1.0 and COnnector/ODBC, further more this link talks
aboout
http://dev.mysql.com/tech-resources/...x.html#ADO.NET
different approaches to connect to mySQL.
My question is which one should I use so that my coding change is
minimum. I guess if I use ODBC then what I need to change is the
connectionstring in my web.config file. But ODBC may not be the best
choice since it is slow? For Connector/Net1.0 I am not sure wether Ent
Lib 2.0 support it or not.
My second question is how can I encrypt the connectionstring in my
web.config file to protect user credential and at the same time the ENt
Lib 2.0 can use the decrypted connectionstring. (where should I decrypt
the connectionstring?)

Sorry for the confusing first post

Thanks again
-rockdale

Jan 9 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

3 posts views Thread by fdsl ysnh | last post: by
8 posts views Thread by poifull | last post: by
3 posts views Thread by veera sekhar kota | last post: by
reply views Thread by veera sekhar kota | last post: by
reply views Thread by veera sekhar kota | last post: by
2 posts views Thread by bjhogan | last post: by
2 posts views Thread by rockdale | last post: by
1 post views Thread by GaryDean | last post: by
reply views Thread by XIAOLAOHU | last post: by
reply views Thread by Vinnie | last post: by
reply views Thread by lumer26 | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.