Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > ASP.NET and ASP > ASP.NET 4 > ASP.NET 4 General Discussion
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
ASP.NET 4 General Discussion For ASP.NET 4 discussions not relating to a specific Wrox book
Welcome to the p2p.wrox.com Forums.

You are currently viewing the ASP.NET 4 General Discussion section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old May 14th, 2011, 09:25 AM
Authorized User
Points: 66, Level: 1
Points: 66, Level: 1 Points: 66, Level: 1 Points: 66, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2010
Posts: 16
Thanks: 10
Thanked 0 Times in 0 Posts
Default Entity Framework and Access Database

After finishing the Beginners ASP.NET 4 book and buying the Professional ASP.NET 4 book from Wrox I'm still unable to use the Entity Framework due to
using Microsoft Access as my Database.

Is there any method to use the EF with MS Access?

I've tried unsuccessfully to convert the database into an SQL Server .mdf database, I've considered trying to draw the schema in the designer but I'm not sure if it will work.

I've Googled this extensively to no avail.
Reply With Quote
  #2 (permalink)  
Old May 14th, 2011, 09:41 AM
Imar's Avatar
Wrox Author
Points: 72,038, Level: 100
Points: 72,038, Level: 100 Points: 72,038, Level: 100 Points: 72,038, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,080
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Hi there,

AFAIK, there is no EF Provider for LINQ. Maybe some third party has created one, but I've never seen it.

Upsizing to a SQL Server database (which you can use with the free Express edition) should be relatively straightforward. Then you can use EF or Linq to SQL...

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
The Following User Says Thank You to Imar For This Useful Post:
R4VEN (May 14th, 2011)
  #3 (permalink)  
Old May 14th, 2011, 09:47 AM
Authorized User
Points: 66, Level: 1
Points: 66, Level: 1 Points: 66, Level: 1 Points: 66, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2010
Posts: 16
Thanks: 10
Thanked 0 Times in 0 Posts
Default

The person co-ordinating this wants an Access database but he knows ASP classic only so I think I'll push to use a SQL Server database instead.

ASP.NET feels more suited to SQL Server, he wanted my Membership database in Access too but I said no.

Thank you! :D

I'm eyeing off the ASP.NET MVC 2 book, it looks like ASP on Rails from the chapter in the Professional book.
Reply With Quote
  #4 (permalink)  
Old May 14th, 2011, 09:57 AM
Imar's Avatar
Wrox Author
Points: 72,038, Level: 100
Points: 72,038, Level: 100 Points: 72,038, Level: 100 Points: 72,038, Level: 100
Activity: 100%
Activity: 100% Activity: 100% Activity: 100%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,080
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

Quote:
he wanted my Membership database in Access too but I said no.
You can do it if you want:

http://imar.spaanjaars.com/560/using...under-aspnet-4

Quote:
so I think I'll push to use a SQL Server database instead.
Yes, for EF or L2S, that's probably the best solution.

Cheers,

Imar
__________________
Imar Spaanjaars
http://Imar.Spaanjaars.Com
Follow me on Twitter

Author of Beginning ASP.NET 4.5 : in C# and VB, Beginning ASP.NET Web Pages with WebMatrix
and Beginning ASP.NET 4 : in C# and VB.
Did this post help you? Click the button below this post to show your appreciation!
Reply With Quote
The Following User Says Thank You to Imar For This Useful Post:
R4VEN (May 14th, 2011)
  #5 (permalink)  
Old May 14th, 2011, 10:09 AM
Authorized User
Points: 66, Level: 1
Points: 66, Level: 1 Points: 66, Level: 1 Points: 66, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Aug 2010
Posts: 16
Thanks: 10
Thanked 0 Times in 0 Posts
Default

I'm totally going to try that Access membership article because I've always thought that was impossible!

But first SQL Server so I can learn .edmx files. :D
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Having problems with Entity Framework Rushino ASP.NET 4 General Discussion 7 June 12th, 2013 05:17 PM
Entity Framework with ACCESS? lsochia BOOK: Beginning ASP.NET 4 : in C# and VB 3 March 18th, 2011 04:07 PM
Entity Framework And MVC geomar BOOK: Professional ASP.NET MVC 1.0 ISBN: 978-0-470-38461-9 5 January 24th, 2011 04:58 PM
The BeerHouse and Entity Framework docluv BOOK: ASP.NET 2.0 Website Programming Problem Design Solution ISBN: 978-0-7645-8464-0 0 October 3rd, 2008 01:32 PM



All times are GMT -4. The time now is 09:59 PM.


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.