How to use entityframework 6 with mono and sqlite for C# cross-platform development?

LINQ/C# Simulation of Cross Context Joins

Maybe something like this can get you started in the right direction. I made a mock database with similar columns based on your column names and got some results.... class Program { static AccountContextDataContext aContext = new AccountContextDataContext(@"Data Source=;Initial Catalog=;Integrated Security=True"); static LoanContextDataC...

On Mono 2.4, using Microsoft Data Entity Framework with Microsoft MVC

You should set CopyLocal = true for the System.Data.Entity assembly as well. You noted that you copied System.Web.MVC local, but never mentioned that you copied System.Data.Entity locally. You might also need to copy local any of the assemblies that System.Data.Entity depends upon that are not part of Mono.

SQLite with EntityFramework with Code-First

System.Data.SQLite... is in current version only EFv1 compatible provider (...1..., ...2...). It means it doesn't have EFv4 (EFv4.2 is wrapper around EFv4) features including database creation and deletion (check ...DbProviderServices... differences for .NET 3.5 and .NET 4.0 in ...MSDN...). Because of that you cannot use automatic database creation...

Error Copying file bin\EntityFramework.SqlServer.xml to ..\bin\EntityFramework.SqlServer.xml failed

Just delete the ...bin... folder from your project directory.... Rebuild the project.... Run the project.... It should solve your issue.... Hope it helps.

Sqlite and EntityFramework 6 Invalid cast on SqlConnection to EntityConnection

I'm facing a InvalidCastException (SqliteConnection to EntityConnection) and is driving me crazy because I don't find much information about it and the one I find simply doesn't work....I guess is something wrong with the app.config file but I've try a lot of things without any result....Also try changing the DbContext but with the same result, no...

System.Data.SQLite ADO.NET Provider cannot be loaded on non development machine

I am trying to port an application from EF3.5 using MS-SQL Server to EF6 using SQLite. Currently the application runs fine on my development machine but as soon as I try to deploy it somewhere else (in this case my Installation-Test-VM), it won't load. Instead I get an exception stating that the ADO.NET Provider with the invariant name 'System.Data...

Connect to PostgreSQL database using EntityFramework 6 (C#)

I am trying to create database on PostgreSQL server using Entity Framework Code-First in C# application. I have downloaded Npgsql for EF and tried to change my App.config file in different ways presented on Internet, however none works....This is my App.config file:...<?xml version="1.0" encoding="utf-8"?> <configuration> <configSections> <!-...

C# The type 'ForeignKeyAttribute' exists in both EntityFramework and System.ComponentModel.DataAnnotations

I upgraded project from .net 4.0 to .net 4.5.1....and I upgraded EntityFramework from 4.3.1 to 6.1.3. ...But EntityFramework based on .net 4.0 (\packages\EntityFramework.6.1.3\lib\net40\EntityFramework) because another depended project running .net 4.0....When I build, I got this error:...The type 'ForeignKeyAttribute' exists in both 'EntityFramewo...

ORA-00955: name is already used by an existing object; When using Oracle.ManagedDataAccess and EntityFramework

I am having a hard time working with EF and Oracle. Earlier, I have developed an app that use EF and Oracle and have ran well. I installed the ODAC in local computer (GAC) that contains Oracle.ManagedDataAccess and Oracle.ManagedDataAccess.EntityFramework....This time I develop an app that using EF and Oracle too, but I just want to use the NuGet p...

How do I restrict the number of columns used in an INSERT when using EntityFramework?

Let's say you have an Entity with 26 columns. It matches the corresponding table which also has 26 columns....From time to time I would like to be able to send fewer columns in an INSERT (Add) operation than are specified in the entity because of certain business rules (In our case we have a trigger on a table that will automatically populate cert...