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.
是否有可以在Classic ASP中使用的OR / M(对象关系映射器)?即使是简化的类对象也会对处理简单的CRUD任务有很大帮助。
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.
是的我知道ASP.NET有很多,我使用它们中的一些用于ASP.NET站点。然而,这是一个使用ASP / VBScript的遗留电子商务网站,并且不可能完全重写。
5 个解决方案
#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.
您可以通过COM Interop使用.net,并在.net中执行ORM。另一种选择是使用Code Smith或MyGeneration并生成VB6类。
Here's some VB6 ORM I have not used or researched any of these: http://www.sparxsystems.com.au/products/ea/features.html
这里有一些我没有使用或研究过的VB6 ORM:http://www.sparxsystems.com.au/products/ea/features.html
If I find anymore Ill update
如果我发现Ill更新了
#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.
没有什么能阻止您使用C#或VB.Net和COM Interop创建可由您的经典ASP页面读取的DLL。我们已经好几次了。
MSDN has two good tutorials on COM Interop.
MSDN有两个关于COM Interop的好教程。
#3
Try my project called Clapper. Its available on Github. https://github.com/jeremychild/Clapper
试试我叫做Clapper的项目。它可以在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
它在这里: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.
我认为IMVHO认为ORM是小型项目的不错选择,但我更喜欢简单直接的ODBC连接。
All the (good) features of the ORMs can be provided by good RDBMS like Oracle or SQL Server.
ORM的所有(好)功能都可以由Oracle或SQL Server等优秀的RDBMS提供。
#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.
您可以通过COM Interop使用.net,并在.net中执行ORM。另一种选择是使用Code Smith或MyGeneration并生成VB6类。
Here's some VB6 ORM I have not used or researched any of these: http://www.sparxsystems.com.au/products/ea/features.html
这里有一些我没有使用或研究过的VB6 ORM:http://www.sparxsystems.com.au/products/ea/features.html
If I find anymore Ill update
如果我发现Ill更新了
#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.
没有什么能阻止您使用C#或VB.Net和COM Interop创建可由您的经典ASP页面读取的DLL。我们已经好几次了。
MSDN has two good tutorials on COM Interop.
MSDN有两个关于COM Interop的好教程。
#3
Try my project called Clapper. Its available on Github. https://github.com/jeremychild/Clapper
试试我叫做Clapper的项目。它可以在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
它在这里: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.
我认为IMVHO认为ORM是小型项目的不错选择,但我更喜欢简单直接的ODBC连接。
All the (good) features of the ORMs can be provided by good RDBMS like Oracle or SQL Server.
ORM的所有(好)功能都可以由Oracle或SQL Server等优秀的RDBMS提供。