I advice to you use entityframework and be careful your database column variable types.
How to set text encoding on a data column from EntityFramework or ADO.NET?
Juan Dent
236
Reputation points
I have a native C++ Windows MFC application that accesses sqlite3.dll to load data from a database and it loads non-ASCII characters like 'ñ' without changing them to '?'
When I access this database from EntityFramework, the non-ASCII characters get represented like '?' instead. Where can I configure EF or ADO.NET to correct this?