Sql Server View to Generic List

David Smith

10y1k

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

6 Replies

Know the answer? Post it — somebody with the same question will find it here.

David Smith10y ago
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.
0
Manas Mohapatra10y ago
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
0
David Smith10y ago
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
0
Manas Mohapatra10y ago
Firstly did you go through the link I provided in my previous answer.

Secondly are you using EntityFramework or what?
0
David Smith10y ago
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.
0
Manas Mohapatra10y ago
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/
0