Hi,
I have a winform.net application that uses Linq to SqlServerCe. The model classes in it have been generated using sqlmetal. I intend to migrate my application to be able to run on linux using the mono runtime. I decided to go ahead with SQLite since SqlServerCe is not planned to be supported in Mono. Now the problem is that there is a ton of code written using linq and I would like to skip the overhead of migrating the entire code and take care of marshalling/unmarshalling myself. I thus wanted to use the SQLite.Net project to meet my requirement.
I have been able to write a small test project (similar to testlinq) and use it on windows. I want to be able to run that on Mono/Linux.
My main questions are:
1. Is it possible to run linq to sqlite using SQLite.Net on mono? (Mono currently doesn't support the System.Data.Entity dll and it seems to be a dependency while using Linq)
2. Since Mono do say that they support Linq, is it possible to use that support and provide a bridge between that and SQLite.Net? (In that case how would the model classes be generated or is it possible to use the sqlmetal classes by enhancing them with SQLite specific attributes
3. Some feedback on the above approach. I am sure I am missing some visibility in between, but where :P
Thanks a lot,
Pulkit