473,692 Members | 2,502 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

2 questions about Microsoft Enterprise Library

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

Jan 8 '07 #1
2 1979
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

Jan 8 '07 #2
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
Jan 10 '07 #3

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

3
2432
by: Harry J | last post by:
Hello, I am new to MS SQL database and have recently downloaded MSDE (Coming in from an Oracle background). I have installed it and have a couple of questions. 1.) Is there a product something like SQLPLUS (hopefully shipped with MSDE) where you can log on to the database and view tables/data/views and so on? 2.) I need to set up an account with a username/password. Is there a executable that I require to be able to perform this task?
4
278
by: Varun | last post by:
Hi I am interested in purchasing visual studio.Net for my company. i just have a few questions that i hope anyone could help me on I will mainly be using it to develop web applications. What i wanted to know is what version i would require? I have seen there is a enterprise architecture, professional, standard etc. I dont really know the differences between these versions I wanted to be able to get away with the minimum purchase. There is...
8
4087
by: poifull | last post by:
Is anyone using the Microsoft Enterprise Library? If yes, do you like it or not? Any feedback will be appreciated.
6
4145
by: Mukesh | last post by:
Hi I have Microsoft Enterprise Library 2005 installed on my local system. I m also using ASp.net 1.1 And C3 as coding language , I have MS Sql Server 2000. I am developing a web application in which i am using data Access Application Block for data access. I have a remote web n data server with asp.net 1.1 support
3
1812
by: Mukesh | last post by:
Hi all As per my earlier conversation with Ciaran (thx for reply) I have installed the MS APplication block on the server , when i ran Build Enterprise Library file and Install Services from (batch files ) programme files menu it was asking for visual studio 2003 , I have only .net framework on the server how can i use the MS application block data access library on my server plz help... Mukesh Agarwal
4
1928
by: Mukesh | last post by:
Hi I m using microsoft application blocks Enterprise Library june 2005 with .net framework 1.1 and VStudio2003 And C# as coding language Sql server 2000 database the project is running properly on the localhost server but my online server does not have the ms Ent lib installed and also de\oes not have visual studio that simply a .net 1.1 installed on that.
3
1729
by: Mukesh | last post by:
Thx Sloan for the solution. It is working properly under Full trust When i tried it under Medium trust it was giving error Parser Error Message: Required permissions cannot be acquired. :::::::::: Source Error:
3
2427
by: Justin Kadima | last post by:
I'm considering porting one of my application in order to use the Microsoft enterprise library and I am contemplating the pros and cons of doing it. Are you guys using the library?
5
2339
by: Michael Howes | last post by:
I'm upgrading a VS 2003/.Net 1.1 ASP.Net application to VS 2008/.Net 3.0 The application uses an older version of the Microsoft Data Blocks for database access. The version in the Microsoft.ApplicationBlocks.Data.dll is 2.0 The call to SqlConnection.Open() fails after I upgrade to .Net 3.0 The application runs under a tweaked version of Medium trust. After the upgrade and the call to .Open() fails if I change the trust to Full the...
0
8547
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
9090
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
8970
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
0
7639
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
6462
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
4329
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
0
4564
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
2984
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
3
1962
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

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.