I have created Indexed view - let's call it PostBank. I keep there Id, CategoryName and UserId. How I get data from PostBank to controller?
Thank You for Your time ;)
SQL command work perfectly, i tested. But I dont know is here possible to use Linq and how?
There is no difference to a table. Just do
SELECT * (or Id, CategoryName, UserId) FROM Postbank
From any client, an indexed view is not different to a table or a view. you can use Linq against, you can do anything you can do against any other view. In fact, there really IS no difference from indexed view to "normal" view ITSELF (afaik, if i am wrong, please give advice, someone), the difference is just the index. You also have no difference (from the clients perspective) between an indexed and unindexed table. Here it is the same.