Using ADO.NET with exisitng MFC Application

[Hari]

Hi Friends,

Please help me for make a solution for the following
problem :

- I would like to use SQL server 2000 with my exisitng
MFC based data acquision/presentation application. I
prefer to use the ADO.NET as the interface (with new its
nice design and features).

As an experimental purpose i just compiled MFC
application with /clr switch. (planning to add ADO.NET
connectivity code). Is it a good way to proceed this way?


The code compiled "fine" but doesn't run (but it took
5times more than the actual compilation time. )

It breaks most the calls with toolbars classes (giving a
typeloadException error).

Is there any better way I could approach to solve this
problem ?(using ADO.NET with MFC application)

Can i try to build the ado.net interfaces in a DLL and
connect to the MFC application (without compiling
with /clr )??

Looking for some inputs::

Hari
Abbott labs

 

[Tommy Vercetti]

I'm in a very similar boat. Short answer: There isn't a better route
than the two you are familiar with.

You can either:

A) Stick with regular C++ and regular ADO (which isn't as easy, clean,
or as fast as ADO.NET but isn't horrible either)

B) Convert to Managed C++ and use ADO.NET. However, as you've noticed,
the Managed C++ route is buggy and filled with all kinds of obscure,
bizarre, hard to resolved problems.