LINQ and access databse

[m.a]

Hello,

I want to use LINQ and ms access. A quick googling showed me that I can not
use LINQ with MS access as LINQ needs a an SQL server, Am I right?. I also
found that if I wrote my own entities to map tables and ... into C# classes,
then I can use LINQ to query database.



Is there any more information about how I can write the entities for a
database?



where can I start to learn?



Any help is very appreciated.



Kind Regards

 

[Arne Vajhøj]

I want to use LINQ and ms access. A quick googling showed me that I can not
use LINQ with MS access as LINQ needs a an SQL server, Am I right?. I also
found that if I wrote my own entities to map tables and ... into C# classes,
then I can use LINQ to query database.

You could read the data from Access to memory and use LINQ for objects.

To be a bit cynical: if your data is too big to have in memory, then
you would want to use SQLServer instead of Access !

Arne

 

[Frans Bouma [C# MVP]]

Hello,

I want to use LINQ and ms access. A quick googling showed me that I can not
use LINQ with MS access as LINQ needs a an SQL server, Am I right?. I also
found that if I wrote my own entities to map tables and ... into C# classes,
then I can use LINQ to query database.

You can use Linq to MS Access using our o/r mapper LLBLGen Pro. See
signature below.

FB

Is there any more information about how I can write the entities for a
database?



where can I start to learn?



Any help is very appreciated.



Kind Regards

--
------------------------------------------------------------------------
Lead developer of LLBLGen Pro, the productive O/R mapper for .NET
LLBLGen Pro website: http://www.llblgen.com
My .NET blog: http://weblogs.asp.net/fbouma
Microsoft MVP (C#)
------------------------------------------------------------------------