DA LINQ

From RemObjects Wiki

This topic is about a Concept in Data Abstract for .NET
Feel free to add your notes to this topic below.

(TODO: needs bringing up to date and expanding)

With the ROFX May 2008 release (5.0.31.701), Data Abstract now has a LINQ query provider for DA services. The LINQ query provider can be found in the RemObjects.DataAbstract.Linq.dll library and has it's own RemoteDataAdapter subclass for LINQ operations. The new RDA has a new option to "Create DA Linq Classes". This option allows you to create a new file with classes that can be used with the LINQRemoteAdapter for your schema. DALINQ makes use of the existing DA-Where infrastructure, thus being able to work with existing services.

Using the LINQ provider is very simple. Queries can be done by using the generic GetTable<> method on the RDA:

var result := 
  from x in MyLINQRemoteDataAdapter.GetTable<Customer> 
  where 
    x.CustomerId = 'ALFKI' 
  select new class(x.CustomerID, x.Name, x.ContactName);

Or in C#:

var result = from c in linqRemoteDataAdapter1.GetTable<Customers>()
             where c.Name == "ALFKI"
             select new { c.Id, c.Name, c.Phone };

See Also

• Lists
  • Namespace Lists for .NET
  • Class Lists for .NET — Delphi — Xcode
  • Interface/Protocol Lists for .NET — Delphi — Xcode
  • Enum Lists for .NET — Delphi — Xcode
  • Alias Lists for Delphi
  • Implements Lists for .NET — Delphi — Xcode
  • Data Types
  • File Types

Product: RemObjects Data Abstract
Available Editions: Data Abstract for .NET, Xcode, Delphi, Java and JavaScript

Glossary   — Articles — Features — Library — Samples