8.3. Using Microsoft Entity Frameworks to Access Progress Schema Objects with Virtuoso
Abstract
This section details the steps required to provide Microsoft Entity Framework access to Progress Schema Objects using the OpenLink Virtuoso Universal Server. This is achieved by Linking the required Progress Schema objects into Virtuoso using its built in Virtual Database engine, and then using the Virtuoso ADO.Net Entity Framework provider to query the remote Progress Schema objects linked into the Virtuoso Server.
8.3.1. Prerequisites
- Progress OpenEdge 10
-
A Progress DBMS hosting the required Schema Objects needs to be available. In this section, the isports sample database will be used to demonstrate the process.
A Progress DBMS hosting the required Schema Objects needs to be available. In this section, the isports sample database will be used to demonstrate the process.
- OpenLink ODBC Driver for Progress (SQL-92)
-
A Progress ODBC Driver is required to link the Progress Schema Objects into the Virtuoso Server. The OpenLink ODBC Driver for Progress (SQL-92) will be used in this section, for which a functional ODBC Data source name of "prs101c" will be assumed to exist on the machine hosting the Virtuoso Server.
A Progress ODBC Driver is required to link the Progress Schema Objects into the Virtuoso Server. The OpenLink ODBC Driver for Progress (SQL-92) will be used in this section, for which a functional ODBC Data source name of "prs101c" will be assumed to exist on the machine hosting the Virtuoso Server.
- OpenLink Virtuoso 5.10.x
-
An OpenLink Virtuoso Universal Server installation including the Virtuoso Universal Server and ADO.NET Entity Framework Provider is required. The Virtuoso components must be Release 5.10.x or above, this being the minimum version containing support for Microsoft Entity Frameworks.
An OpenLink Virtuoso Universal Server installation including the Virtuoso Universal Server and ADO.NET Entity Framework Provider is required. The Virtuoso components must be Release 5.10.x or above, this being the minimum version containing support for Microsoft Entity Frameworks.
- Microsoft Visual Studio 2008 + SP1
-
Microsoft Visual Studio 2008 with Service Pack 1 is required, this being the only version containing the necessary Entity Framework support available at the time of writing.
Microsoft Visual Studio 2008 with Service Pack 1 is required, this being the only version containing the necessary Entity Framework support available at the time of writing.