Is there an OR/M for Classic ASP?

2019-04-25 07:04发布

问题:

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.

回答1:

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



回答2:

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.



回答3:

Try my project called Clapper. Its available on Github. https://github.com/jeremychild/Clapper



回答4:

I also created a framework, but not is so strong than some frameworks said above, is a simple but very useful framework and helped me a lot.

It's here: https://github.com/FelipeNathan/asp-orm

and it's in portuguese



回答5:

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.