sql authority - Page 933

List of well known VSS Writer GUIDs

- by Hannes de Jager

Is there a consolidated list of GUIDs for well known VSS writers available somewhere? At least the Microsoft ones like System State, Exchange, SQL, Sharepoint etc.

I'm having a hard time determining the best way to handle this... With Entity Framework (and L2S), LINQ queries return IQueryable. I have read various opinions on whether the DAL/BLL should return IQueryable, IEnumerable or IList. Assuming we go with IList, then the query is run immediately and that control is not passed on to the next layer. This makes it easier to unit test, etc. You lose the ability to refine the query at higher levels, but you could simply create another method that allows you to refine the query and still return IList. And there are many more pros/cons. So far so good. Now comes Entity Framework and lazy loading. I am using POCO objects with proxies in .NET 4/VS 2010. In the presentation layer I do: foreach (Order order in bll.GetOrders()) { foreach (OrderLine orderLine in order.OrderLines) { // Do something } } In this case, GetOrders() returns IList so it executes immediately before returning to the PL. But in the next foreach, you have lazy loading which executes multiple SQL queries as it gets all the OrderLines. So basically, the PL is running SQL queries "on demand" in the wrong layer. Is there any sensible way to avoid this? I could turn lazy loading off, but then what's the point of having this "feature" that everyone was complaining EF1 didn't have? And I'll admit it is very useful in many scenarios. So I see several options: Somehow remove all associations in the entities and add methods to return them. This goes against the default EF behavior/code generation and makes it harder to do some composite (multiple entity) LINQ queries. It seems like a step backwards. I vote no. If we have lazy loading anyway which makes it hard to unit test, then go all the way and return IQueryable. You'll have more control farther up the layers. I still don't think this is a good option because IQueryable ties you to L2S, L2E, or your own full implementation of IQueryable. Lazy loading may run queries "on demand", but doesn't tie you to any specific interface. I vote no. Turn off lazy loading. You'll have to handle your associations manually. This could be with eager loading's .Include(). I vote yes in some specific cases. Keep IList and lazy loading. I vote yes in many cases, only due to the troubles with the others. Any other options or suggestions? I haven't found an option that really convinces me.

Search Results

Search found 27905 results on 1117 pages for 'sql authority'.

Page 933/1117 | < Previous Page | 929 930 931 932 933 934 935 936 937 938 939 940 | Next Page >

- by Hannes de Jager

- by Nelson

- by stefano

- by matt

- by niao

- by olst

- by Rob

- by jpanewbie

- by Wade73

- by Keith

- by Marcus

- by mada

- by Jacksta

- by dthrasher

- by Haskella

- by nils petersohn

- by Carson

- by bandhunt

- by Campos

- by David Rabinowitz

- by user121196

- by BALAMURUGAN

- by shantanuo

- by user284950

- by Tass-man

< Previous Page | 929 930 931 932 933 934 935 936 937 938 939 940 | Next Page >