Linq To Sql - Distinct

Question

i want to return a disctinct list of manufacturers from my products table.
so far i got:

var manufacturers = db.ExecuteQuery<string>("SELECT DISTINCT Manufacturer FROM Product");

seems a little... dirty?

is there a better way of doing it? i only want to return a List<string> or something similar...

Answer 1

Do we have to buy the liscence of crystal report for using in the asp.net

Answer 2

Hi Thanks for writing below links helpful for you.......

http://www.c-sharpcorner.com/UploadFile/009464/how-to-use-crystal-report-in-Asp-Net-using-C-Sharp/

http://tektutorialshub.com/how-to-create-crystal-report-using-visual-studio/

https://code.msdn.microsoft.com/ASPNET-MVC-SAP-Crystal-e0564cac