score:6
you can do this using nhibernate, since it supports ms access as a backend. here are the details of using nhibernate with ms access. it uses nhibernate.jetdriver.dll to access the jet data engine (ms access).
just realize that ms access isn't going to give you the same performance/support/etc as most other db backends with an orm.
score:-3
i just answered my own question...
i can just establish the odbc connection in server explorer, and drag the tables straight into a predefined dataset and use a tableadapter.fill()
score:0
the dll for using nhibernate to acccess seems to be on sourceforge (just googling, not checking)
http://sourceforge.net/project/shownotes.php?release_id=460590
if you are just querying access, it might be worth defining views in a relationnal database
this way you will have a solution for using a form of cache/snapshot later on(for example by converting your views into table that you refresh each hour/ 5min. etc depending on your expectations)
if the performance degrade too much.
Source: stackoverflow.com
Related Query
- Best way to do ORM with Access DB as datasource
- Best way to query XDocument with LINQ?
- Best way to use LINQ to Entities with a Collection Property
- Best way to handle redundant code that has repeated logic?
- Code Cleanup: Best way to split long statement over multiple lines
- What is the best way to sort a List of objects with a start value?
- Is there any way to make Code Contracts work with LINQ?
- What is the best way to order a list by numeric field and put objects with value of 0 at the bottom?
- Best way to offset an enumerable with itself
- What's the best way to copy and insert data from related tables into a new set of related tables with Linq
- Best way to get range from 1 to n-1 with linq
- Best way to add null value to IEnumerable as First Record with an example
- Best way to write Dynamic Query with dynamic result with Linq or Expression Tree
- Any way to access to a variable of type "var", defined in code behind, from aspx file?
- How best to implement a login system in VB.NET using LINQ to compare information with an Access table?
- Best way to return a list of a particular property from a list with objects
- Is there a better way to achieve this with Linq or a better code
- Best way to simplify boolean check in c# with a lot of different possibilities
- What's The Best Way To Remove Duplicate Rows Based On A Row Item In A DataTable With VB.Net?
- Best way to convert list data to another with a desired format in c# using LINQ
- Best way to find if a value is present in the array, and if so execute code
- Performance wise what is the best way to compare 2 DataTables with approximate 1000 records?
- How can I bind a query with a join to a GridView, with a Linq datasource with a business layer and data access layer
- Best way to copy Data from one DataTable to another DataTable with diffrent 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
- Best way to add unknown number of columns to Datatable and populate with data?
- Best way to Access data from two databases in linq
- Best way to compare 3 lists with different types of data
- Easier way to populate a list with integers in .NET
- Best way to remove multiple items matching a predicate from a .NET Dictionary?
More Query from same tag
- Can I access the NHibernate ISession instance from IQueryable?
- Mapping select query to an object makes an error in linq
- Converting a linq Join into a left join
- Is it possible to refactor this nHibernate Linq query?
- Set key inside order by clause in linq dynamically
- LINQ Include error
- How to use order by when using the group by in LINQ
- Why is it deleting from other variable while I am Removing from different variable in C#.net?
- LINQ Union different types - dynamically casting to an interface?
- VB.Net and Linq syntax with regards to bracketing
- How to get only one value from the record in the list in c#?
- Entity using include to load related tables but how to left outer join it
- How to write a properly joined query with method based syntax in Entity SQL?
- Look for built-in class like StructuralEqualityComparer<T> with generic version
- Using Linq Select to create a new inherited object
- Error "The LINQ expression node type 'Invoke' is not supported in LINQ to Entities" in where clause inside the method
- LInq to Sql query with Group by
- Linq select where in list
- EF Core 5.0 Union Linq Query with sub selects not working
- Using FromSqlRaw or Linq query to Group and Sum data
- LinqDataSource: How to assign IQueryable value to where parameters in code
- Formatting a string using values from a generic list by LINQ
- Linq outer join using inequality?
- Th linq query could not be translated. Either rewrite the query in a form that can be translated .NETCore
- Selecting a tree from a csv using LinQ
- Linq to XML vs DOM
- Linq results to a var does not populate values unless refreshed manually
- How can i combine two object fields in Object List into one DropDown in mvc
- C# method call delegation
- How to populate one extra property in a .Select - LINQ