• Aug 22, 2017 • #entity-framework #sqlite

  SQLite & EF Core: UDF all the things!

  We recently had two community contributions for using user-defined functions (UDFs) in EF Core and Microsoft.Data.Sqlite that synergize well together. I thought I’d write a sarcastic blog post showing you how you can make everything a UDF whether or not it should be.

• Jul 20, 2017 • #sqlite

  Bulk Insert in Microsoft.Data.Sqlite

  You’ve got a large set of data to import into your SQLite database, but you can’t find the bulk insert API in Microsoft.Data.Sqlite. That’s because there isn’t one! SQLite doesn’t have any special way to bulk insert data.

• Jul 5, 2017 • #entity-framework #sql-server

  Test EF Core using SQL Server Docker images

  Some tests in the Entity Framework Core codebase require features only available on Microsoft SQL Server Developer Edition or higher. Since most developers only have Microsoft SQL Server 2016 LocalDB (and even then only because it was installed by Visual Studio), it can be troublesome to run these tests.

• Jan 4, 2017 • #entity-framework

  Custom Migrations History Table in EF Core

  This post demonstrates the different ways you can customize the migrations history table in EF Core.

• Dec 13, 2016 • #entity-framework

  Validation in EF Core

  In Entity Framework 4.1+ we would validate entities before sending them to the database. See Entity Framework Validation to read more about it.

• Oct 23, 2016 • #msbuild

  Paket-like NuGet with MSBuild

  Say what you’d like about XML vs. JSON. (I like YAML) I’m still very excited about NuGet’s deeper integration with MSBuild. That’s because MSBuild is so much more than its antiquated file format. It’s an execution engine that enables you to define configuration and sets of data, transform that data, then process it using various tasks.

• Jun 13, 2016 • #sqlite

  Encryption in Microsoft.Data.Sqlite

  One of the frequently asked questions about Microsoft.Data.Sqlite is: How do I encrypt a database? I think that one of the main reasons for this is because System.Data.SQLite comes with an unsupported, Windows-only encryption codec that can be used by specifying Password (or HexPassword) in the connection string. The official releases of SQLite, however, don’t come with encryption.