LINQ and MS Access

[=?Utf-8?B?TmVpbCBC?=]

I've JUST move to Vista, VS 2008, C# from XP, VS.net 2002, VB & C++ so I'm on
a steep learning curve.

I'm currently developing a C# Web App project in VS 2008. I need to query an
existing MS Access data base. I thought LINQ would be the way to go.

Can you suggest a good example of C#, LINQ, code that will get me started
with accessing a MS Access data base??

Thanks, Neil

[=?Utf-8?B?UGV0ZXIgQnJvbWJlcmcgW0MjIE1WUF0=?=]

RE: LINQ and MS Access

if you are on such a "steep learning curve" from all your migrations to newer
this and newer that, it might be a good idea to lessen the steepness for a
bit and just concentrate on how to query MS Access with plain old ADO.NET
using the OleDb provider. Once you've got that under your belt, you can add
LINQ into the mix.
-- Peter
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short Urls & more: http://ittyurl.net


"Neil B" wrote:

I've JUST move to Vista, VS 2008, C# from XP, VS.net 2002, VB & C++ so I'm on
a steep learning curve.
>
I'm currently developing a C# Web App project in VS 2008. I need to query an
existing MS Access data base. I thought LINQ would be the way to go.
>
Can you suggest a good example of C#, LINQ, code that will get me started
with accessing a MS Access data base??
>
Thanks, Neil

[=?Utf-8?B?TmVpbCBC?=]

RE: LINQ and MS Access

I'll keep that in mind. However, I'm still interested in looking at a LINQ
solution.
Can you point me to a good example that will get me connected to an Access
DB??

Thanks, Neil

"Peter Bromberg [C# MVP]" wrote:

if you are on such a "steep learning curve" from all your migrations to newer
this and newer that, it might be a good idea to lessen the steepness for a
bit and just concentrate on how to query MS Access with plain old ADO.NET
using the OleDb provider. Once you've got that under your belt, you can add
LINQ into the mix.
-- Peter
Site: http://www.eggheadcafe.com
UnBlog: http://petesbloggerama.blogspot.com
Short Urls & more: http://ittyurl.net
>
>
"Neil B" wrote:
>

I've JUST move to Vista, VS 2008, C# from XP, VS.net 2002, VB & C++ so I'm on
a steep learning curve.

I'm currently developing a C# Web App project in VS 2008. I need to query an
existing MS Access data base. I thought LINQ would be the way to go.

Can you suggest a good example of C#, LINQ, code that will get me started
with accessing a MS Access data base??

Thanks, Neil

[Marc Gravell]

Re: LINQ and MS Access

So why would Microsoft release their new query solution without support for

one of their most popular databases???

Popular with who? Probably not the same set of people who might be
using LINQ. It just about works for single user (OK, maybe a handful
of users) in a destkop app, but you aren't really going to use LINQ
inside such. And if you don't need the desktop app side of things, SQL
Express makes a good choice... with far fewer of Access's
limitations...

But this is one of those polarizing things. Personally I wouldn't
recommend access, but that might just be me.

Marc

[Marc Gravell]

Re: LINQ and MS Access

(note that I'm only using SQL Express here as a comparison to entry-
level tools like Access; obviously SQL Server / Oracle kick in at some
point...)

[Frans Bouma [C# MVP]]

Re: LINQ and MS Access

Marc Gravell wrote:

So why would Microsoft release their new query solution without
support for one of their most popular databases???

>
Popular with who? Probably not the same set of people who might be
using LINQ. It just about works for single user (OK, maybe a handful
of users) in a destkop app, but you aren't really going to use LINQ
inside such. And if you don't need the desktop app side of things, SQL
Express makes a good choice... with far fewer of Access's
limitations...
>
But this is one of those polarizing things. Personally I wouldn't
recommend access, but that might just be me.

I don't see ms access as an enterprise multi-user database, but it's
really suitable for a desktop app's local db. For example, it has more
features than the horrible crap called SqlServer CE Desktop.

FB


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

[Marc Gravell]

Re: LINQ and MS Access

I'll readily defer to your judgement on most database things.

But for the record I wasn't comparing it to that *particular* beast...
I guess it depends on whether you can get away with installing SQL Server
Express Edition - obviously the jet driver itself is smaller and more
portable. If the app is for full-time usage, then you probably can. If it is
just a quick standalone smart-client, then probably not.

As always, then, the answer probably starts with "it depends"...

;-p