Integration Testing Entity Framework code first with in-memory database

by

Use SQL Compact 4.0 (download both SqlCE and tools by web platform installer) – EF Code first has direct support for that. The only difference will be that your application will use connection string to big SQL Server:

<add name="MyDbContext" 
     provider="System.Data.SqlClient" 
     connectionString=
       "Data Source=...;InitialCatalog=...;Integrated Security=SSPI" />

and your tests will use connection string to SQL Compact:

<add name="MyDbContext" 
     provider="System.Data.SqlServerCe.4.0" 
     connectionString="Data Source=Database.sdf" />

More Related Contents:

  1. near “varchar”: syntax error [closed]
  2. How do I make an UPDATE while joining tables on SQLite?
  3. How do I rename a column in a SQLite database table?
  4. How to set Sqlite3 to be case insensitive when string comparing?
  5. Escape single quote character for use in an SQLite query
  6. One DbContext per request in ASP.NET MVC (without IOC container)
  7. Difference between 2 dates in SQLite
  8. Update with Join in SQLite
  9. Can I read and write to a SQLite database concurrently from multiple connections?
  10. How do I store and retrieve a blob from sqlite?
  11. SQLite error ‘attempt to write a readonly database’ during insert?
  12. Store boolean value in SQLite
  13. SQLite add Primary Key
  14. Encrypted cookies in Chrome
  15. Overriding SaveChanges and setting ModifiedDate, but how do I set ModifiedBy?
  16. How delete table inner join with other table in Sqlite?
  17. ALTER TABLE ADD COLUMN IF NOT EXISTS in SQLite
  18. Create table in SQLite only if it doesn’t exist already
  19. Entity framework code-first null foreign key
  20. How do you ensure Cascade Delete is enabled on a table relationship in EF Code first?
  21. Navigation Property without Declaring Foreign Key
  22. How do DATETIME values work in SQLite?
  23. Add ON DELETE CASCADE behavior to an sqlite3 table after it has been created
  24. Entity Framework Database.SetInitializer simply not working
  25. Entity Framework Code First : Setting up One-To-One foreign key association using Annotations
  26. How to set unique constraint over multiple columns when any one can be null?
  27. How to display blob value using x’abc’ binary string literal syntax?
  28. Unable to load DLL sqlite3 in Universal Windows App running on Mobile
  29. DbFunctions.TruncateTime LINQ equivalent in EF CORE
  30. How to get the last index of a substring in SQLite?

Leave a Comment