LINQ and access databse

  • Thread starter Thread starter m.a
  • Start date Start date
M

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
 
m.a said:
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.
Click to expand...

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
 
m.a said:
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.
Click to expand...

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
Click to expand...


--
------------------------------------------------------------------------
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#)
------------------------------------------------------------------------
 
Back
Top