Just Curious

[Super Lloyd]

Do you mean something like

(from row in context.Person
where row.Name.Contains("foo")
select row).Take(10).ToList()

Do you (erroneously) "oppose it" to something like

context.Person.Where(x => x..Name.Contains("foo")).Take(10).ToList()

I guess I do then... but I usually use both syntax. Sometimes in the same query.

A new .NET Serializer All in one Menu-Ribbon Bar Taking over the world since 1371!

[Jorgen Andersson]

Or you can roll your own.

Wrong is evil and must be defeated. - Jeff Ello

[MadMyche]

I use it almost weekly; as an example of what not to do

Director of Transmogrification Services Shinobi of Query Language Master of Yoda Conditional

[RickZeeland]

Too busy with community engineering on CodeProject nowadays :-\

[Sander Rossel]

How often have you ported it?

Best, Sander sanderrossel.com Continuous Integration, Delivery, and Deployment arrgh.js - Bringing LINQ to JavaScript Object-Oriented Programming in C# Succinctly

[PIEBALDconsult]

Frack, no.

[Lost User]

I've got both Windows and Kubuntu running here; not using the database-servers dailect of SQL makes it easy to switch databases.

Bastard Programmer from Hell :suss: If you can't read my code, try converting it here[^] "If you just follow the bacon Eddy, wherever it leads you, then you won't have to think about politics." -- Some Bell.

[Jorgen Andersson]

You mean rolling your own and posting an article about it? :)

Wrong is evil and must be defeated. - Jeff Ello

[RickZeeland]

Quote:

A nod's as good as a wink to a blind bat.

:-\

[Jacquers]

I used to... but not anymore.

[DJ van Wyk]

Daily, yes. You just have to be very careful with how you write the queries and constantly inspect what Linq-to-SQL projects into actual SQL. Sometimes Linq is so clever that it project terrible and slow queries but in most cases you can fix it by "rewording" your Linq queries. I believe Entity Framework has the same projection problem.

My plan is to live forever ... so far so good

[decaffeinatedMonkey]

Entity Framework Core for me. I like how it does migrations, and if done right, it can be portable across multiple database engines.

[darktrick544]

Never have, I dont mind writing proper code

[Mario Luis]

Nope. MS did suggest a while ago that it should not be used production wise, rather use EF or some such.

[obermd]

Nope. Since I write mainly in VB I find the Linq syntax to be very cumbersome and hard to use. When I write in C# I'm far more likely to use Linq simply because the lambda syntax is far easier to read and use. In neither case do I use Linq -> SQL

[agolddog]

Me too.

[ventureaaron]

It is the recommended way for SharePoint 2010 CRUD according to "SharePoint 2010 Dev with VS2010" by E. Carter et al. I use it and love having some of that back end taken care of (and i've really grown to like Linq). but as someone else said i use straight up SQL when the going gets tough.

[BrentHolmstrom]

Tried it for a project but quickly had to abandon it. Found it too rigid. If you try using against a many databases. When one database adds a field, it completely breaks querying the table. Though I enjoyed learning about CROSS APPLY from examining it but discovered that it hits a cap where it performs better than anything else in a limited use environment, but once you pass a threshold it takes down systems.