Sql Server View to Generic List

Question

I have a view in in SQL Server to Generic List.

viewGetAllColorNames

How do I write linq to get data from the view above call get "viewGetAllColorNames".

The viewGetAllColorNames sql statement is simply.

SELECT ID , ColorName , ColorNumber
FROM colorTable

David Smith · Answer

i was trying to avoid doing it that way in the linq. But if thats the only quick way that you know I will just do it that way. I saw the link you provided.

Manas Mohapatra · Answer

Go through below link that will help you: http://stackoverflow.com/questions/6601302/using-a-view-from-sql-server-2008-in-c-sharp-asp-net

David Smith · Answer

I am not using entity framework at all. To late in the game to use entity framework. The will be a future update. I just have a stored procedure to get data. I want to be able to get list into a generic datatable or list so I can use later in memory

Manas Mohapatra · Answer

Firstly did you go through the link I provided in my previous answer. Secondly are you using EntityFramework or what?

David Smith · Answer

Is there away to quickly through the list into a global generic so that I can use the data for a lookup dictionary. Also I am not forsure what is  EFTipsSampleEntities. I do not have that object. What is that object referencing. I simply want to get the data and store it in a save generic list for later. How to accomplish this using a view.

Manas Mohapatra · Answer

Hi David View behaves like a table in EntityFramework. So you can use same query which are using to fetch records from a table. Let's your view name viewGetAllColorNames using (EFTipsSampleEntities ctx = new EFTipsSampleEntities()) { var result = (from t in ctx. viewGetAllColorNames select t).ToList ColorClass >(); foreach (var t in result) { Console.WriteLine({0} {1} {2}  t.ID t. ColorName  t. ColorNumber ); } } Note: Here ColorClass is your generic class which contains properties like ID ColorName ColorNumber. You need to change as per your need. Please go through below that will help you more: https://www.mssqltips.com/sqlservertip/1990/how-to-use-sql-server-views-with-the-entity-framework/