Entity Framework with ACCESS?

lsochia · March 17th, 2011, 04:47 PM

The application I'm developing uses ACCESS 2007, I "think" I need the data tools that EF provides to complete this application. Can I use an ACCESS database?

All I really need is to be able to gain access to array info in the code behind.

Thanks in advance!

Imar · March 18th, 2011, 04:47 AM

Hi there,

There's no provider for Microsoft Access for the Entity Framework. That is, it's not listed here: http://msdn.microsoft.com/en-us/data/dd363565.aspx and I've never seen it. That means you can't use Microsoft Access to build a model in Visual Studio.

Quote:

All I really need is to be able to gain access to array info in the code behind.

I don't understand what you're saying here.

You could use raw ADO.NET to access the database, or look into typed datasets.

Cheers,

Imar

lsochia · March 18th, 2011, 02:28 PM

Regarding what I'm trying to do... this will definitely show my ignorance

I have a display form that shows one complete record which the user has selected from a previous list. The display form uses some pull-downs which need to be set to the value of whatever the selected record is.

I could pass that pull-down value in the URL like I do the ID but it seems to me that all I really need to pass is the ID and the code behind should be able to figure out all the data for that record. I want to set the value of the pull-downs in the code behind.

I'm certain this is a very basic thing.. I know that ID represents all the data connected to that record I just don't know how to get access to it in the code behind.... that's why I was looking into entities.

Imar · March 18th, 2011, 04:07 PM

Hi there,

I am not sure I understand your requirements completely, but I think you can accomplish this with the SqlDataSource and some SelectParameters that get data from the Query String. Check out Chapter 13 for more details.

Cheers,

Imar