Enabling Foreign key constraints in SQLite

by

Finally figured this out from this post. The PRAGMA foreign_key setting does not persist but you can set it every time the connection is made in the ConnectionString. This allows you to use Visual Studio’s table adapters.

  1. Make sure you have the latest version (1.0.73.0) of system.data.sqlite installed (1.0.66.0 will not work).
  2. Change your ConnectionString to data source=C:\Dbs\myDb.db;foreign keys=true; (replace C:\Dbs\myDb.db with your sqlite database).

More Related Contents:

  1. How can I add user-supplied input to an SQL statement?
  2. How to use DbContext.Database.SqlQuery(sql, params) with stored procedure? EF Code First CTP5
  3. Pass table valued parameter using ADO.NET
  4. SQLite Database Locked exception
  5. Is it necessary to manually close and dispose of SqlDataReader?
  6. How to save image in database using C# [closed]
  7. SqlBulkCopy from a List
  8. How to fill Dataset with multiple tables?
  9. Getting the Last Insert ID with SQLite.NET in C#
  10. ExecuteNonQuery returning -1 when using sql COUNT despite the query string
  11. How do I translate a List into a SqlParameter for a Sql In statement? [duplicate]
  12. Add WHERE clauses to SQL dynamically / programmatically
  13. Check if a SQL table exists
  14. Unable to find the requested .Net Framework Data Provider – SQLite
  15. How do I extract data from a DataTable?
  16. How to give ADO.NET Parameters
  17. Do we have transactions in MS-Access?
  18. Automated checking of database connection and query in same database [closed]
  19. In sqlite I would do, But how in mongodb c#
  20. Validation failed for one or more entities while saving changes to SQL Server Database using Entity Framework
  21. Handling ExecuteScalar() when no results are returned
  22. Wildcard search for LINQ
  23. Is SqlCommand.Dispose() required if associated SqlConnection will be disposed?
  24. Get an IDataReader from a typed List
  25. Does using parameterized SqlCommand make my program immune to SQL injection?
  26. The property ‘Id’ is part of the object’s key information and cannot be modified
  27. Problems using Entity Framework 6 and SQLite
  28. Direct method from SQL command text to DataSet
  29. How to use String property as primary key in Entity Framework
  30. How to get efficient Sql Server deadlock handling in C# with ADO?

Leave a Comment