| Attributes | Values |
|---|
| type
| |
| Date Created
| |
| Date Modified
| |
| label
| - VirtEntityFrameworkOODBCDatService
|
| maker
| |
| Title
| - VirtEntityFrameworkOODBCDatService
|
| isDescribedUsing
| |
| has creator
| |
| attachment
| |
| content
| - %META:TOPICPARENT{name="VirtODBCEntityFrameworkUsage"}%
---+++Creating an ADO.Net Data Service for ODBC-Compliant Databases
An ADO.Net Data Service for the Microsoft Access Northwind tables can be created using the Entity Data Model created in the <i>[[VirtOODBCEDM][Creating EDM in Visual Studio 2008]]</i> section.
1 Open the <b><nop>VirtuosoDataService</b> project created in the <i>[[VirtOODBCEDM][Creating EDM in Visual Studio 2008]]</i> section.%BR%%BR%
1 Right click on the <b><nop>VirtuosoDataService</b> project name in the <b>Solution Explorer</b> pane. Then, select the <b>Add</b> -> <b>New Item</b> menu options.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataServices_4.png" style="wikiautogen"/>%BR%%BR%
1 The <b>Add New Item</b> dialog will appear. Choose the <b>ADO.NET Data Service</b> template. Give it the name <b><code>Virtuoso.svc</code></b> and click <b>Add</b> to create the ADO.Net Data Service.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataServices_15.png" style="wikiautogen"/>%BR%%BR%
1 In the newly created <b><code>Virtuoso.svc.cs</code></b> Data Service file, add the data source class name of <b><code><nowiki>VirtuosoEntities</nowiki></code></b> (note this is the name set in the <i>[[VirtOODBCEDM][Creating EDM in Visual Studio 2008]]</i> section) as the <b><nop>DataService</b> name. Enable access to the Data Service by adding the entry <b><code><nowiki>config.SetEntitySetAccessRule("*", EntitySetRights.All);</nowiki></code></b> to the <b><code><nowiki>InitializeService</nowiki></code></b> method.
<verbatim>
// C#
using System;
using System.Web;
using System.Collections.Generic;
using System.ServiceModel.Web;
using System.Linq;
using System.Data.Services;
namespace SimpleDataService
{
public class Northwind : DataService<VirtuosoDemoEntities>
{
public static void InitializeService(IDataServiceConfiguration config)
{
config.SetEntitySetAccessRule("*", EntitySetRights.All);
}
}
}
</verbatim>
%BR%%BR%<img src="%ATTACHURLPATH%/VirtAdoNetDataServices_16.png" style="wikiautogen"/>%BR%%BR%
1 To test the Data Service, simply hit <b>Ctrl+F5</b> within Visual Studio. This will start the development web server, run the Data Services server inside, and load a Web browser page displaying the list of available tables/entities for the Microsoft Access Northwind database catalog.
%BR%%BR%<img src="%ATTACHURLPATH%/VirtEntityFrameworkOODBCDatService1.png" style="wikiautogen"/>%BR%%BR%
1 To access a specific entity instance like the Customers table ALFKI record, use this convention: <b><code><nowiki>http://host/vdir/Virtuoso.svc/Customers('ALFKI')</nowiki></code></b> .
%BR%%BR%<img src="%ATTACHURLPATH%/VirtEntityFrameworkOODBCDatService2.png" style="wikiautogen"/>%BR%%BR%
---+++NOTES
1 <b>Important</b> - To view <b>Atom</b> (the default format returned by an ADO.NET Data Service) in Internet Explorer, you must first ensure that <b>Feed Reading View</b> is turned <b>off</b>. This can be done on the <b>Content tab</b> of <b>Tools<b> in <b>Internet Options</b>.%BR%%BR%
1 If a Data Services entity instance URI page fails to load, you can turn <b>Verbose</b> errors on by adding <b><code><nowiki>config.UseVerboseErrors = true;</nowiki></code></b> in the <b><code><nowiki>virtuoso.svc.cs InitializeService</nowiki></code></b> method to obtain more detailed information from the server as to why the page failed to load:
<verbatim>
public static void InitializeService(IDataServiceConfiguration config)
{
config.UseVerboseErrors = true;
config.SetEntitySetAccessRule("*", EntitySetRights.All);
}
</verbatim>
CategoryDocumentation CategoryVirtuoso CategoryEntityFramework CategoryDotNET CategoryODBC CategoryODBCODBCBridge
|
| id
| - f4e059fb79449b2726e554bfb8b5a7de
|
| link
| |
| has container
| |
| http://rdfs.org/si...ices#has_services
| |
| atom:title
| - VirtEntityFrameworkOODBCDatService
|
| links to
| |
| atom:source
| |
| atom:author
| |
| atom:published
| |
| atom:updated
| |
| topic
| |
| is made
of | |
| is container of
of | |
| is link
of | |
| is http://rdfs.org/si...vices#services_of
of | |
| is links to
of | |
| is creator of
of | |
| is atom:entry
of | |
| is atom:contains
of | |
![[RDF Data]](/fct/images/sw-rdf-blue.png)
![[cxml]](/fct/images/cxml_doc.png)
![[csv]](/fct/images/csv_doc.png)
![[text]](/fct/images/ntriples_doc.png)
![[turtle]](/fct/images/n3turtle_doc.png)
![[ld+json]](/fct/images/jsonld_doc.png)
![[rdf+json]](/fct/images/json_doc.png)
![[rdf+xml]](/fct/images/xml_doc.png)
![[atom+xml]](/fct/images/atom_doc.png)
![[html]](/fct/images/html_doc.png)