Is there an OR/M for Classic ASP?

views:

245

answers:

+5 Q:

Is there an OR/M for Classic ASP?

Is there an OR/M (object relational mapper) that can be used in Classic ASP? Even a simplified class object would be a great help in handling simple CRUD tasks.

Yes I know ASP.NET has many and I use a few of them for ASP.NET sites. However this is a legacy e-commerce site that uses ASP/VBScript and a total rewrite it not a possibility.

+3 A:

You could use .net through COM Interop, and do your ORM in .net. Another option would be to use Code Smith, or MyGeneration and generate VB6 classes.

Here's some VB6 ORM I have not used or researched any of these: http://www.sparxsystems.com.au/products/ea/features.html

If I find anymore Ill update

JoshBerke 2009-05-05 14:07:00

thanks! I appreciate the edits and links.

Brian Boatright 2009-05-05 14:13:54

No problem your best bet is still build the stuff in .net and use interop, this will start you on the path to migration. I would recommend you try and build everything in .net actually and use various bridging techniques. We had a classic asp app which was a beast but was able to bring .net to various backend systems and even the front end (Through IFrames)

JoshBerke 2009-05-05 14:16:34

+2 A:

There is nothing stopping you from using C# or VB.Net and COM Interop to create a DLL that could be read by your classic ASP page. We have done that several times.

MSDN has two good tutorials on COM Interop.

Gary.Ray 2009-05-05 14:09:36

thanks for the tutorial links.

Brian Boatright 2009-05-05 14:13:13

I think IMVHO that ORM is a good choice for small projects but I prefer the easy and direct ODBC connections for larger ones.

All the (good) features of the ORMs can be provided by good RDBMS like Oracle or SQL Server.

ATorras 2009-05-05 14:26:14

ansaurus

tags:

views:

answers:

Is there an OR/M for Classic ASP?

related questions