Clever Geek Handbook

How to use VS lightwitch with MS Access Database

It is possible to create a Lightswitch application that connects to an MS access database using WCF RIA services. However, I am completely new to WCF and the official documentation on how to do this is confusing.

I just want to connect my lightwitch app to my existing MS access database. Is there a simplified tutorial on how to achieve this?

+3


source to share


1 answer


This post is from Michael Washington and should guide you through the steps to configure the RIA services that Lightswitch will use.

Now the problem is with MS Access. Access is not supported in EntityFramework, so the step where you have to add "ADO.NET Entity Data Model" will not work the same.



In my opinion, you have the following possibilities:

  • Migrate your ACCESS database to SQL Server.
  • Add your ACCESS database as a linked server in SQL Server (Express Edition [Free]) and then create a new SQL database with views getting data from the linked server access tables.
  • Find a third-party provider written for Access.
  • Create your own supplier.
  • ????
+2


source






More articles:


All Articles