Linq to SQL available in Xamarin?

Question

Can you use LINQ to SQL in Xamarin?

I want to query a SQL Server DB (not SQLite), and want to know if LINQ is an option.

Answer 1

You should get your data via a web service. (which can use linq to sql or entity framework)

After you have it in your app, you can use a sqlite database in your app to store it and operate on it locally with linq to sql.

At this point you do need a way to synchronizes the local and server database.

This way you can provide offline access to your app.

Answer 2

It is not considered a good design to make the database available through the internet for several reasons. Instead you should think about writing a web service that your app consumes and operates on. This way you gain more control of the actions that should be done on your database.