Best pracise for using Linq within a 3 Tier project

[Ilyas]

Hi all

What is the recommended way for using Linq within a 3 Tier project?

Many thanks

 

[Cor Ligthert[MVP]]

Ilyas,

Do you mean a multilayer solution?.

However for that is as well AFAIK the best solution, don't use LINQ. This
because Linq is an expression language meant to get fast extractions from
data and submit the changes to the database in a simple way.

Cor

 

[Jon Skeet [C# MVP]]

Do you mean a multilayer solution?.

However for that is as well AFAIK the best solution, don't use LINQ. This
because Linq is an expression language meant to get fast extractions from
data and submit the changes to the database in a simple way.

1) LINQ isn't just meant for databases
2) I don't see how your description of LINQ (to SQL) in any way makes
it unsuitable for multilayer solutions

 

[Cor Ligthert [MVP]]

1) LINQ isn't just meant for databases

Did I write that?

2) I don't see how your description of LINQ (to SQL) in any way makes
it unsuitable for multilayer solutions

Did I say so, I thought that the general opinion was that it is not the
"best" practise for multilayer solutions.

Cor

 

[Jon Skeet [C# MVP]]

Did I write that?

Read what you wrote - there's no real need to mention databases at all
in my view. Your statement is biased towards databases when I'd just
say that LINQ is a set of technologies to ease data access, whatever
the data source.

Did I say so

You said that if you want the best solution, don't use LINQ. That
sounds like you feel it's unsuitable.

I thought that the general opinion was that it is not the
"best" practise for multilayer solutions.

I don't think so. You may not use it in all layers (although LINQ to
Objects is almost always useful, IMO) but there's nothing wrong with
using LINQ in multi-layer solutions. You still need to solve a lot of
the same problems as before in terms of concurrent updates etc, but
LINQ will help in various ways.

 

[Andy]

Did I say so, I thought that the general opinion was that it is not the
"best" practise for multilayer solutions.

No, that would be the opposite of the general opinion.