Why would I need Genome when LINQ is available now?
Genome uses LINQ as its primary query language and provides features on top of it in order to reap maximum benefit from LINQ. But let us delve a little further into this because it is a common source of confusion: LINQ in itself is not an O/RM. LINQ represents a sort of lingua franca for expressing query logic – this is why it is a great bonus for Genome.
However, LINQ cannot translate and process queries; it merely allows query expressions to be built. Translating those into SQL code requires an O/RM tool. At minimum, the tool should translate LINQ query expressions into SQL code.
However, an O/RM can offer features that go far beyond this simple translation task. Genome for example offers advanced caching, update tracking, forward and reverse engineering, concurrency control features and much more. This is also where Genome’s advantage over LINQ2SQL, Microsoft’s basic O/RM tool for translating LINQ queries into SQL, becomes apparent.