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).
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.