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/article
I found article "Specifying Views In the Entity Data Model (EDM) Wizard" http://developer.teradata.com/blog/dsakai/2011/04/
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.