Tagged Questions
2
votes
1answer
148 views
Is it okay to convert dataset from stored procedure to IEnumerable
So, I am working on a project with a team and we are using Entity Framework. We basically want to use linq to entities, and not use stored procedures. I use quite a bit of lists and IEnumerables and ...
2
votes
2answers
392 views
Is it better to create a stored procedure or entities to get to the data I need?
I just jumped into a new project with a new company using Entity Framework and ASP.NET MVC 4. I am no expert on Entity Framework, but I think I have a decent grasp of how to use it.
From what I can ...
2
votes
1answer
719 views
Nesting Linq-to-Objects query within Linq-to-Entities query –what is happening under the covers?
var numbers = new int[] { 1, 2, 3, 4, 5 };
var contacts = from c in context.Contacts
where c.ContactID == numbers.Max() | c.ContactID == numbers.FirstOrDefault()
...
3
votes
1answer
123 views
Are elements returned by Linq-to-Entities query streamed from the DB one at the time or are they retrieved all at once?
Are elements returned by Linq-to-Entities query streamed from the database one at the time ( as they are requested ) or are they retrieved all at once:
SampleContext context = new ...
3
votes
4answers
272 views
What is the most effective order to learn SQL Server, LINQ, and Entity Framework?
I am trying to get some advice on what order I should learn about SQL Server, LINQ, and Entity Framework to be able to better work with ASP.NET Webforms and MVC.
From what I've been able to learn so ...
5
votes
1answer
8k views
Entity Framework vs. Linq to SQL? [closed]
I'm a little bit confused about these two terms "Linq to SQL" and "Entity Framework". I have the general idea that both of them somehow allow you to refer to database tables as .net objects or ...
7
votes
4answers
1k views
LINQ vs Data Access Layer
I've taught myself always to handle any data access code in a completely separate 'layer' to my business logic and UI code. This has always been a very good architecture for me and any 'rules' or best ...
7
votes
3answers
4k views
In ASP.NET MVC3 controllers, where do you instantiate your DataContext?
In your ASP.NET MVC 3 applications that use a DataContext or DbContext, where do you instantiate your data access object?
Here is a non-exhaustive list of where I've seen it done:
Individually ...
18
votes
5answers
2k views
MVC, WCF, EF, LINQ - Is it just me? [closed]
...or are things getting more complicated?
It seems to me that you need to know a lot of stuff to 'properly' develop an MS web app these days. In the bad old days when we didn't know any better we ...
3
votes
4answers
1k views
Should I be learning Linq, Direct SQL Commands (in .net), EF or other?
Basically, I have a very good knowledge of plain old SQL coming from Classic ASP programming.
Over the past couple of months, I have been learning C# and today was my first full day at MVC 3 (Razor) ...
