Last post Sep 12, 2014 07:10 PM by PatriceSc
Sep 12, 2014 05:32 PM|mandrews1234|LINK
So I've been using linq for a few years now and love it. I'd say I'm just above a novice on knowledge of it though so I have this problem.
My new company wants me to head up a new branch of our website because I'm really good with UI, and have a lot of new (html5 css3 etc) experience, where a lot of our seasoned devs don't.
I'm ok with that but I have this question. Throughout our existing site, we have some intense select statements. With tons of inner joins, where's etc. and I'm wondering if implementing linq is still a good idea? We also sometimes might have to pull 20k
records on a single page, and I was just unsure if I went my normal routine of setting up my model layer, and returning the data from that would be a good idea.
I know that's kind of vague but I can't think of a better way of putting it without writing 10 paragraphs. Any advice?
Sep 12, 2014 07:10 PM|PatriceSc|LINK
Whatever you are using, 20k records seems too much. What do you do with that much data? You are showing all this to the user? Usually you try to filter/page data to just show them what they really need to see.
Anyway EF allows to let you go at the SQL level if/when needed so if you use EF you can do both, if you use ADO.NET, you can't use EF at all...