score:1
First, note that LINQ-to-SQL is not (AFAIK) validated for use on Access. It generally works, but MMMV.
Personally, I would approach this by importing (migrating) the tables from the Access database into a SQL Server Express instance, and using that to generate the model (of course, the tooling might even work against Access, but I assume they don't - hence the question). With the model generated, you should be able to point it (at runtime - via connection-string or connection) at your access database instead.
You might also consider: why not leave it as a SQL Server Express node - it works well, and is better supported in terms of LINQ-to-SQL.
Note also that there are other LINQ-to-SQL-like tools that may work for your purposes; DbLinq, dapper-dot-net, etc - and a few more heavy-weight tools (EF, NHibernate, LLBLGen Pro, etc)
score:1
XPO, an ORM tool from Developer Express, would allow you to create .Net classes directly from your Access 2007/2010 database and use Linq to create queries.
The good thing is that if you wish to change database backend, say for instance that you transferred your data from Access to SQL Server or MySQL or PostgreSQL, etc you just need to change the database connection string, not your code.
Source: stackoverflow.com
Related Articles
- how to automatically create a class compatible with the access table?
- Automatically create correct class of object when pulling data with LINQ
- How To Create Generic Data Access Object (DAO) CRUD Methods with LINQ to SQL
- Create table with Linq to Sqlite (linq2db)
- how to create a pivot table with dynamic column using linq tree expression
- Map class to tables with different table names but same column structure
- C# How to Create a Custom (dynamic) class with Dynamic Linq using XElement in runtime
- Create c# class with a table. Sqlite-net
- Create a class type in code in .net c#
- How to create a new DateTime where condition using table field with LINQ
- Make access possible to dynamic table LINQ EF6 Code First
- MVC 5 unable to create controller with Linq to SQL class
- Is there a good way to create a one-way table by a multiple choice result with linq?
- How to create a class to use with LINQ?
- nhibernate table pr hierarchy fetching specific class with LINQ
- SQLite DB: Create a SQL Statement with LINQ that uses the same table twice but without CROSS JOIN
- Join table with linq into object-list in class
- Create a C# Generic class for repeated code
- Create a tree structure in linq with a single list source with parent - child as strings of an object
- How to Create a generic method with 1 known property. Want to dynamic get the properties in different class with Generic Class property
- How does EF create the SQL needed to update one million rows in a SQLite table with five million rows? Does it do one by one row updates?
- Using a class in joining to database table with EF
- Can't access to middle table in LINQ with entity framework?
- how to create a left join query for a many to many related table with LINQ
- Create a table of data by month with totals
- How to access many to many mapped table in c# with Entity Framework
- Generic code to determine how many rows from a table are in a different table with matching structure?
- Best way to compare two classes (Users and Holidays) and create a list of Users who have not created an instance of the Holiday class with LINQ
- fill object data source with class in another project
- Create list with data from grouped Linq query plus related data from another table
- How can I use custom expressions in DevArt LINQ to Entities and also use query comprehension syntax?
- C# Search filters- ignore specific diacritics
- Take n elements. If at end start from begining
- How can I check if the integer value of a string is less than something in LINQ?
- Get subset of rows from table and filter after the query is executed
- How to use LINQ with dynamic collections
- sort list-of-lists using linq and custom sorting rules
- How to determine if all objects inside List<T> has the same property value using Linq
- Check if following items exist in the List<T>
- split list to multiple list on property basis
- Why is type parameter treated as object in expression?
- Cannot access to a specific block of XML file with Linq
- How to get item from a list that position in a certain place
- Query the value of an item`s property of a JArray with json.net
- Linq order by, group by and order by each group?
- Group by two columns count
- Return table records based on user role / table Join failing - linq query
- Why does DataTable.Rows not have a .Where() method?
- Trying to parse XML and create a List information using Linq and C#
- Entity splitting with inherited models
