sqlite
Release: SSIS Data Flow Components Update – ver. 2.1
We are pleased to announce the release of the long-awaited update for SQL Server Integration Services Data Flow components (SSIS), version 2.1.
SSIS is...
Using SQLite ODBC with .NET on Simple Examples
If you want to know everything about SQLite ODBC and how to use it with .NET, you are on the right way. In...
Code-First Migrations and EF Core Support Improvements in dotConnect for SQLite 5.18
The new version of Devart dotConnect for SQLite contains significant improvements of Entity Framework Core support, improving Entity Framework Core Code-First Migrations a...
Entity Framework 6.3 and .NET Core 3 Support
.NET Core 3
.NET Core was presented by Microsoft in 2016, but its 1.x versions had limited set of features comparing to Full .NET Framework....
Increasing SQLite Performance
One the major issues a developer encounters when using the SQLite DBMS in his applications is its performance issue.
Perhaps, a classic case everyone gets...
Using SQLite Full-Text Search in Entity Framework
Introduction
SQLite database supports an advanced functionality of full-text search (FTS) and full-text indexing described comprehensively in the SQLite documentation: SQLite FTS3 and FTS4 Extensions.
We...
Dynamic Database Creation in Entity Framework
Entity Framework 4 RC allows you to create and drop databases in run-time using SSDL for DDL generation. Now ObjectContext has CreateDatabase(), DropDatabase(), and...
Entity Framework 4 Release Candidate supported!
We have supported new functionality of Entity Framework 4 including Entity Framework v4 Release Candidate for dotConnect for Oracle, dotConnect for MySQL, dotConnect for...
Entity Framework Canonical Functions
Article was updated on 3/4/2010
This article can be useful for programmers who want to develop cross-database applications and use the canonical functions.
Entity Framework Canonical...
SQLite UDFs : Adding Sqrt and CToF functions
According to the list of core functions in SQLite, there is no native support for the most mathematics functions (sqrt, log, etc). Furthermore, user...
