2 questions about Microsoft Enterprise Library

[rockdale]

Hi, all

I am using Enterprise Library for .NET Framework 2.0 - January 2006 to
access my backend MS SQL database. As now we are consider migrate sql
database to mySQL. What engine (ODBC or MySQL for .NET) should I use so
that the code change wil be minimum?

Also, as the enterprise lib using connectionstrin gs in web.config to
access the database, is there a way to encrypt this connectionstrin g,
do I need to change the Enterprise Library. ( I did not find the place
that the DBFactory get the connectionstrin g)
Thanks a lot
-rockdale

[sloan]

The Enterprise Library is supposed to insulate you from the db of choice, as
far as the DotNet is concerned.

You should have a DataLayer object(s).

The datalayer object ~uses the EnterpriseLibra ry.Data class as a ~~helper
....

Your datalayer object will return
IDataReaders
DataSets
scalars
and occasionaly voids.

You then only have to put in the correct information in the web.config file
for mySQL.

You don't get a connectionstrin g from the EnterpriseLibra ry. That's not its
function.

Its function is to create an abstract way to talk to ~any datastore, with
the same syntax, regardless of vendor.
All you have to do is set the correct config file settings.
You can look at this blog:
http://sholliday.spaces.live.com/blog/

to see how to create a correct datalayer assembly and object(s).

"rockdale" <ro************ @gmail.comwrote in message
news:11******** *************@v 33g2000cwv.goog legroups.com...

Hi, all

I am using Enterprise Library for .NET Framework 2.0 - January 2006 to
access my backend MS SQL database. As now we are consider migrate sql
database to mySQL. What engine (ODBC or MySQL for .NET) should I use so
that the code change wil be minimum?

Also, as the enterprise lib using connectionstrin gs in web.config to
access the database, is there a way to encrypt this connectionstrin g,
do I need to change the Enterprise Library. ( I did not find the place
that the DBFactory get the connectionstrin g)
Thanks a lot
-rockdale

[rockdale]

Well, I guess I did not 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
http://dev.mysql.com/tech-resources/...x.html#ADO.NET
talks about different approaches to connect to mySQL.

My question is which one should I use so that my code change is
minimum. I guess if I use ODBC then what I need to change is the
connectionstrin g in my web.config file only, but ODBC may not be the
best choice since it is slow? For Connector/Net1.0 I am not sure
whether Ent Lib 2.0 support it or not and how to implement it to let
Ent Lib 2.0 to support it.
My second question is how can I encrypt the connectionstrin g in my
web.config file to protect user credential and at the same time the ENt
Lib 2.0 can use the decrypted connectionstrin g. (where should I decrypt
the connectionstrin g?)

Sorry for the confusing first post

Thanks again
-rockdale

sloan wrote:

The Enterprise Library is supposed to insulate you from the db of choice, as
far as the DotNet is concerned.

You should have a DataLayer object(s).

The datalayer object ~uses the EnterpriseLibra ry.Data class as a ~~helper
...

Your datalayer object will return
IDataReaders
DataSets
scalars
and occasionaly voids.

You then only have to put in the correct information in the web.config file
for mySQL.

You don't get a connectionstrin g from the EnterpriseLibra ry. That's not its
function.

Its function is to create an abstract way to talk to ~any datastore, with
the same syntax, regardless of vendor.
All you have to do is set the correct config file settings.
You can look at this blog:
http://sholliday.spaces.live.com/blog/

to see how to create a correct datalayer assembly and object(s).

"rockdale" <ro************ @gmail.comwrote in message
news:11******** *************@v 33g2000cwv.goog legroups.com...

Hi, all

I am using Enterprise Library for .NET Framework 2.0 - January 2006 to
access my backend MS SQL database. As now we are consider migrate sql
database to mySQL. What engine (ODBC or MySQL for .NET) should I use so
that the code change wil be minimum?

Also, as the enterprise lib using connectionstrin gs in web.config to
access the database, is there a way to encrypt this connectionstrin g,
do I need to change the Enterprise Library. ( I did not find the place
that the DBFactory get the connectionstrin g)
Thanks a lot
-rockdale