Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / .NET Framework / ADO.NET / January 2006

Tip: Looking for answers? Try searching our database.

Middle tier Data access object in .net assembly or COM?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
david - 27 Jan 2006 15:29 GMT
Hi,
I am new in VS.net. We try to migrate our VB6 application to .net. In our
VB6 application, we have a middle tier data access object to handle the
connection and stored procedures' calls. Do we still do middle tier DO in
COM? or in just Assembly? why?
Thanks in advance,
DW
W.G. Ryan - MVP - 27 Jan 2006 17:13 GMT
> Hi,
> I am new in VS.net. We try to migrate our VB6 application to .net. In our
> VB6 application, we have a middle tier data access object to handle the
> connection and stored procedures' calls. Do we still do middle tier DO in
> COM? or in just Assembly? why?
--I guess in large part it depends on how you're writing the application.
Is your goal to try to migrate everything at once? If so, then it probably
makes sense to do everything in .NET. Your back end Teir is where there's
going to be the most pronounced difference considering that you'll want to
use ADO.NET instead of classic ADO.  But compartively speaking, this will in
all likelihood have a large impact on your middle tier as the consumer.
With that said, you can create an assembly (or multiple ones) for each tier
which is probably the most straightforward way( however there's a lot more
to architecture then this so I don't want to downplay that angle).  You may
want to take a look at the TaskVision application or one of the started kits
in ASP.NET for general guidance on how to set up a particular project. If
getting the project done is your main goal, then you probably want to reuse
as much of your existing application base as possible and migrate the
pieces.  You can create wrappers for each of the to hold your place on an
intermediate basis and then move them over whever you have time to fully
rewrite them.  The "Why" part of your question will be answered in large
part by the "Why" of your migration in the first place. You'll probably find
that as far as the IDE goes, you can be notably more productive with the
.NET IDE than the old VB6 IDE (granted this is largely a matter of opinion
vs an irrefutable fact) and if you're doing web development, you'll probably
find that working in .NET will be far more productive than say COM/VB6IDE
and Visual Interdev.  For this, or the performance boost you get with
ASP.NET over classic ASP, or the new language features, you may want to bit
the bullet and just migrate everything now.  On the other hand, the bigger
your existing code base, the more likely it is that you'll want to reuse
what you have and move over the pieces.  I know it probably sounds like a
dodge of an answer but the devil will really be in the details. Perhaps if
you can mention some more of the specific challenges coupled with your
reason and philosophy for switchin,g, it'd be easir to provide more
feedback.

Cheers,

Bill
> Thanks in advance,
> DW
William (Bill) Vaughn - 28 Jan 2006 03:20 GMT
Generally, .NET applications migrate middle-tier COM components to Web
Services. However, each architecture is different and has different demands
so it might still make sense to stick with DCOM.

Signature

____________________________________
William (Bill) Vaughn
Author, Mentor, Consultant
Microsoft MVP
INETA Speaker
www.betav.com/blog/billva
www.betav.com
Please reply only to the newsgroup so that others can benefit.
This posting is provided "AS IS" with no warranties, and confers no rights.
__________________________________

> Hi,
> I am new in VS.net. We try to migrate our VB6 application to .net. In our
[quoted text clipped - 3 lines]
> Thanks in advance,
> DW

Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.