How do you connect to a DB View with OData in Visual Studio?

Connectivity

How do you connect to a DB View with OData in Visual Studio?

Does anyone know how to connect to a DB View with OData service in Visual Studio? I can connect to DB tables, as in the tutorial: Creating an OData service using .NET Data Provider for Teradata (http://developer.teradata.com/connectivity/articles/creating-an-odata-service-using-net-data-provide...). But I cannot select a particular View.

I found article "Specifying Views In the Entity Data Model (EDM) Wizard" http://developer.teradata.com/blog/dsakai/2011/04/specifying-views-in-the-entity-data-model-edm-wiza..., but it's from 2011 and is very cumbersome and frankly out of my expertise. I would think there is an easier way by now. Does anyone know or have been able to connect to a view relatively easily?

I am using both VS2010, Win7, .NET Data Provider for Teradata 14.11 release. I also have VS2012, but that does not even list Teradata as an installed product (topic of another post).

1 REPLY
Teradata Employee

Re: How do you connect to a DB View with OData in Visual Studio?

Sorry, there is no other workaround for Views (vs. Tables). However you can create an entity based on a "Defining Query": http://msdn.microsoft.com/en-us/data/jj730307.aspx . This limitation is related to the Data Dictionary DBC.ColumnsV[X] in the Teradata Database. It does not return Column Metadata for Views.