CFG2.SQLiteLib 1.0.2

There is a newer version of this package available.
See the version list below for details.
dotnet add package CFG2.SQLiteLib --version 1.0.2
                    
NuGet\Install-Package CFG2.SQLiteLib -Version 1.0.2
                    
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="CFG2.SQLiteLib" Version="1.0.2" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="CFG2.SQLiteLib" Version="1.0.2" />
                    
Directory.Packages.props
<PackageReference Include="CFG2.SQLiteLib" />
                    
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add CFG2.SQLiteLib --version 1.0.2
                    
#r "nuget: CFG2.SQLiteLib, 1.0.2"
                    
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#:package CFG2.SQLiteLib@1.0.2
                    
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=CFG2.SQLiteLib&version=1.0.2
                    
Install as a Cake Addin
#tool nuget:?package=CFG2.SQLiteLib&version=1.0.2
                    
Install as a Cake Tool

CFG2.Utils.SQLiteLib

A library of SQLite functions.

Nothing in here is rocket science, but IMO it make it easier to work with SQLite for things like dynamically creating/updating tables and running common CRUD type functions.

Usage Examples

using CFG2.Utils.SQLiteLib;

public class Program
{
    private SQLiteUtil sqliteUtil;

    static void Main(string[] args)
    {
        sqliteUtil = new SQLiteUtil("c:\path\to\sqlite.db");

        sqliteUtil.RegisterField(new FieldDef("MY_TABLE", "KEY_ID", DataType.TEXT));
        sqliteUtil.RegisterField(new FieldDef("MY_TABLE", "VALUE_X", DataType.TEXT));
        sqliteUtil.RegisterField(new FieldDef("MY_TABLE", "DEBUG_X", DataType.TEXT));
        sqliteUtil.RegisterField(new FieldDef("MY_TABLE", "CREATED_DT", DataType.EXT_DATETIME));

        Record record = new Record();
        record.AddField("KEY_ID", "key");
        record.AddField("VALUE_X", "value");
        record.AddField("CREATED_DT", DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"));
        sqliteUtil.InsertRecord(table, record);
    }
}

Release Notes

1.0.0

  • Initial Release
Product Compatible and additional computed target framework versions.
.NET net9.0 is compatible.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 was computed.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages (1)

Showing the top 1 NuGet packages that depend on CFG2.SQLiteLib:

Package Downloads
CFG2.AppLib

Package Description

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
1.0.3 457 7/20/2025
1.0.2 277 7/20/2025
1.0.1 281 7/20/2025
1.0.0 261 7/14/2025