Database APIs

Entity Framework Core is a modern object-database mapper for .NET. It supports LINQ queries, change tracking, updates, and schema migrations. EF Core works with SQL Server, Azure SQL Database, SQLite, Azure Cosmos DB, MySQL, PostgreSQL, and other databases through a provider plugin API. Commonly Used Types: Microsoft.EntityFrameworkCore.DbContext Microsoft.EntityFrameworkCore.DbSet

NOTE: As of the 1.0 release, package IDs for SQLitePCL.raw now begin with SQLitePCLRaw.*. Some use cases will involve minor breaking changes in the transition. See README on GitHub for more info. These extension methods for SQLitePCL.raw provide a more usable API while remaining stylistically similar to the sqlite3 C API, which most C# developers would consider 'ugly'. This package exists for people who (1) really like the sqlite3 C API, and (2) really like C#. So far, evidence suggests that 100% of the people matching both criteria are named Eric Sink, but this package is available just in case he is not the only one of his kind.

EntityFramework.Functions library implements Entity Framework code first support for - Stored procedures (with single result type, multiple result types, output parameter), - Table-valued functions (returning entity type, complex type), - Scalar-valued functions (composable, non-composable), - Aggregate functions, - Built-in functions, - Niladic functions, - Model defined functions. EntityFramework.Functions library works on .NET Standard with Entity Framework 6.4.0. It also works on .NET 4.0, .NET 4.5, .NET 4.6, .NET 4.7, .NET 4.8 with Entity Framework 6.1.0 and later. It can be installed through Nuget: - dotnet add package EntityFramework.Functions Or: - Install-Package EntityFramework.Functions -DependencyVersion Highest For more information, see: - Document (APIs and examples): https://weblogs.asp.net/Dixin/EntityFramework.Functions - Source code: https://github.com/Dixin/EntityFramework.Functions - Nuget package: https://www.nuget.org/packages/EntityFramework.Functions

FluentData is a Micro ORM that makes it simple to select, insert, update and delete data in a database. It gives the developer the power of ADO.NET but with the convenience of an ORM. It has a simple to use fluent API that uses SQL - the best and most suitable language to query data, and SQL or fluent builders to insert, update and delete data.

Core library for Essential.Diagnostics, with a common base class for trace listeners. It also includes a generic formatter, a generic expression-based trace filter, and a file watcher for configuration changes. Other Essential.Diagnostics packages extend the .NET Framework System.Diagnostics trace logging with additional trace listeners. Included are colored console (that allows custom formats), SQL database (including a tool to create tables), rolling file (with custom formats), rolling XML, email (per trace or batched), and an in-memory trace listener. The Essential.Diagnostics project also publishes structured data (semantic) tracing extensions and a fluent client library that includes easy encapsulation of activity and logical operation scopes, as well as abstractions and templated classes for a simpler logging API and support for dependency injection frameworks. See the project site on GitHub for examples and documentation.

ArangoDB-NET is C# based driver for .NET/mono framework which implements ArangoDB REST API.

Core functionality API objects for ADONetHelper based libraries

IQToolkit ORM for System.Data database providers (core API and shared libraries).

Package Description

Rolling file trace listener extension for System.Diagnostics, along with required config sections. Writes to a text file, rolling to a new file based on a filename template (usually including the date). Other Essential.Diagnostics packages extend the .NET Framework System.Diagnostics trace logging with additional trace listeners. Included are colored console (that allows custom formats), SQL database (including a tool to create tables), rolling file (with custom formats), rolling XML, email (per trace or batched), and an in-memory trace listener. The Essential.Diagnostics project also publishes a fluent client library that includes easy encapsulation of activity and logical operation scopes, as well as abstractions and templated classes for a simpler logging API and support for dependency injection frameworks. See the project site on CodePlex for examples and documentation.

Colored console trace listener extension for System.Diagnostics, along with required config sections. Writes to the console output or error stream, using color to highlight event types and allowing a customised output format. Other Essential.Diagnostics packages extend the .NET Framework System.Diagnostics trace logging with additional trace listeners. Included are colored console (that allows custom formats), SQL database (including a tool to create tables), rolling file (with custom formats), rolling XML, email (per trace or batched), and an in-memory trace listener. The Essential.Diagnostics project also publishes a fluent client library that includes easy encapsulation of activity and logical operation scopes, as well as abstractions and templated classes for a simpler logging API and support for dependency injection frameworks. See the project site on CodePlex for examples and documentation.

ThinkingHome plugin which provide database API (PostgreSQL) for other plugins.

.NET Library for loading data fast (doing bulk inserts) into a SQL Server Compact database file. Attempts to mimic the SqlClient SqlBulkCopy API.

Light weight wrapper for Firebase Realtime Database REST API. Supports streaming API Create Update Delete

CqlSharp is a high performance, asynchronous Cassandra CQL binary protocol client implementing the ADO.NET data provider interfaces. It's main features are: * The API implements the ADO.NET interfaces. If you are familiar with SqlConnection, SqlCommand, and SqlReader, you should be able to use CqlSharp with no difficulty. * CqlSharp is an implementation of the CQL Binary Protocols v1, v2, and v3 and therefore requires Cassandra 1.2 and up * CqlSharp supports all the binary protocol v2 features: batching, paging, bound query variables, result schema caching, check-and-set (CAS) statements, and sasl-authentication * CqlSharp supports all the binary protocol v3 features: more queries per connection, timestamp property, UDT and Tuple types, larger collections * Supports fast mapping of objects to query parameters, or query results to objects. Mapping is tunable by decorating your classes via Table and Column attributes. * Extremely fast, highly flexible and extendable type (conversion) system. Automatically converts parameters and results to the requested types. * Query tracing, timeouts and cancellation is supported * Configuration is done through connection strings. The simultaneous use of multiple Cassandra clusters is supported. * Extensive logging, including support for custom logger implementations See https://github.com/reuzel/CqlSharp/wiki/Features for an extensive feature list.

Email trace listener extension for System.Diagnostics, along with required config sections. Sends each trace message received in an email, using the specified subject and body templates. Note: Set a filter to avoid flooding (don't rely on trace source switch value). Other Essential.Diagnostics packages extend the .NET Framework System.Diagnostics trace logging with additional trace listeners. Included are colored console (that allows custom formats), SQL database (including a tool to create tables), rolling file (with custom formats), rolling XML, email (per trace or batched), and an in-memory trace listener. The Essential.Diagnostics project also publishes a fluent client library that includes easy encapsulation of activity and logical operation scopes, as well as abstractions and templated classes for a simpler logging API and support for dependency injection frameworks. See the project site on CodePlex for examples and documentation.

Riz.XFramework is a lightweight and high performance object-relational mapper for .NET use the native Entity Framework api.

Provides Couchbase Lite with a self-hosted REST API.

An out-of-the-box Web API for invoking database stored procedures, transforming the results as JSON, BSON, JSONP, XML, CSV, Excel xlsx, or any text generated by Razor dynamic template. Please visit https://github.com/DataBooster/DbWebApi for detail.

Package Description

Rolling file version of the XML trace listener extension for System.Diagnostics, along with required config sections. Writes E2ETraceEvent XML fragments to a text file, rolling to a new file based on a filename template (usually including the date). The E2ETraceEvent XML fragment format can be read by the Service Trace Viewer tool. Other Essential.Diagnostics packages extend the .NET Framework System.Diagnostics trace logging with additional trace listeners. Included are colored console (that allows custom formats), SQL database (including a tool to create tables), rolling file (with custom formats), rolling XML, email (per trace or batched), and an in-memory trace listener. The Essential.Diagnostics project also publishes a fluent client library that includes easy encapsulation of activity and logical operation scopes, as well as abstractions and templated classes for a simpler logging API and support for dependency injection frameworks. See the project site on CodePlex for examples and documentation.

In memory trace listener extension for System.Diagnostics, along with required config sections. This listener is useful for unit testing that logging has occurred. Other Essential.Diagnostics packages extend the .NET Framework System.Diagnostics trace logging with additional trace listeners. Included are colored console (that allows custom formats), SQL database (including a tool to create tables), rolling file (with custom formats), rolling XML, email (per trace or batched), and an in-memory trace listener. The Essential.Diagnostics project also publishes a fluent client library that includes easy encapsulation of activity and logical operation scopes, as well as abstractions and templated classes for a simpler logging API and support for dependency injection frameworks. See the project site on CodePlex for examples and documentation.

SQL database trace listener extension for System.Diagnostics, along with required config sections. Trace listener that writes to the database connection specified into a table created by the included diagnostics_regsql.exe tool (in the package tools directory). Other Essential.Diagnostics packages extend the .NET Framework System.Diagnostics trace logging with additional trace listeners. Included are colored console (that allows custom formats), SQL database (including a tool to create tables), rolling file (with custom formats), rolling XML, email (per trace or batched), and an in-memory trace listener. The Essential.Diagnostics project also publishes a fluent client library that includes easy encapsulation of activity and logical operation scopes, as well as abstractions and templated classes for a simpler logging API and support for dependency injection frameworks. See the project site on CodePlex for examples and documentation.

Core component of Backload filehandler without bundeling feature. Backload is a professional, full featured server side file handler for ASP.NET (MVC, Web API, ASP.NET WebForms). It handles the client side jQuery File Upload Plugin from blueimp, PlUpload from Moxiecode and Fine Uploader from Widen Enterprises out of the box, but it can be easily customized to work with any client side plugin. More than 20 examples in demo packages. Continually developed and backed by the software industry. Demo package: https://github.com/blackcity/Backload/ Licenses: Standard (free), Pro/Enterprise licenses starting from $19.90. Web: https://www.backload.org

Buffered email trace listener extension for System.Diagnostics, along with required config sections. Adds formatted trace messages to a buffer and sends an email when the process exits, or on request. Other Essential.Diagnostics packages extend the .NET Framework System.Diagnostics trace logging with additional trace listeners. Included are colored console (that allows custom formats), SQL database (including a tool to create tables), rolling file (with custom formats), rolling XML, email (per trace or batched), and an in-memory trace listener. The Essential.Diagnostics project also publishes a fluent client library that includes easy encapsulation of activity and logical operation scopes, as well as abstractions and templated classes for a simpler logging API and support for dependency injection frameworks. See the project site on CodePlex for examples and documentation.

Minimalistic API allows developer to most easily perform operations with database. By default, library automatically manages DbConnection, DbTransaction, DbCommand and DbDataReader objects. Developer only writes queries.

TZM.XFramework is a lightweight and high performance object-relational mapper for .NET use the original Entity Framework api.

Library of .NET extensions and components - adapter framework, process queue, configuration api, diagnostics, error handling, active directory, interop, checksums, ftp, mail, unit conversion, binary parsing, scheduler, ntp time, precision timer, int24, unit24, console extensions, database extensions, drawing extension, reflection extensions, xml extensions, bit extensions, buffer extensions, char extensions, data-time extensions, enum extensions, string extensions.

TZM.XFramework is a lightweight and high performance object-relational mapper for .NET use the original Entity Framework api.

Recommended Google client library to access the Google Cloud Datastore API, which accesses the schemaless NoSQL database to provide fully managed, robust, scalable storage for your application.

ASP.NET Library that enables fast development of REST API that read data from SQL Server 2016+ and Azure SQL database. enables easy creation of JQUeyr DataTable and OData REST API.

Simple RESTlike and Subscription API server in C#

Complex C# library for Firebase Realtime Database built on top of Firebase REST API. Among others it supports following: * Offline storage * Querying using available filters * Passing in authentication token * Streaming online changes * Directly Posting / Putting / Patching online data Streaming changes (both online and offline) are done using Reactive Extensions.

An out-of-the-box Web API for invoking database stored procedures, transforming the results as JSON, BSON, JSONP, XML, CSV, Excel xlsx, or any text generated by Razor dynamic template. Please visit https://github.com/DataBooster/DbWebApi for detail.

Dapper.Fluent is a small and easy library that supports fluent API for query construction and execution over database connection using Dapper.Net.

InfluxData.Net is a fast, portable .NET library to access the REST API of an InfluxDB database and Kapacitor processing tool. The library supports .Net Framework v4.6.1 and .Net Standard v2.0.

An out-of-the-box Web API for invoking database stored procedures, transforming the results as JSON, BSON, JSONP, XML, CSV, Excel xlsx, or any text generated by Razor dynamic template. Please visit https://github.com/DataBooster/DbWebApi for detail.

MongoDbMigrations uses the official MongoDB C# Driver to migrate your documents in your mongo database via useful fluent API. Supports up and down migrations with cancelation and progress handling. Also, this library is able to check a schema of collections in your database during the migration run. This version supports on-premise Mongo database either Azure CosmosDB (with Mongo-like API) or even AWS DocumentDB. In addition you can use TLS and/or SHH tunnels in your migrations. PS1 script for integration with CI/CD pipelines provides inside of the repository

SQLitePCL.raw is a Portable Class Library (PCL) for low-level (raw) access to SQLite. This package does not provide an API which is friendly to app developers. Rather, it provides an API which handles platform and configuration issues, upon which a friendlier API can be built. On platforms (like Android or iOS) where SQLite is preinstalled, this package may be all you need. On other platforms, or if you want to use a different SQLite build, see the SQLitePCL.plugin.* packages. (Note that with the 0.8.0 release, the ID of this package changed from 'SQLitePCL.raw_basic' to 'SQLitePCL.raw'. Eventually, the old ID will stop getting updates.)

Restful API wrapper for the GiantBomb games database public API

Semiodesk Trinity is a high-level C# API for querying and manipulating RDF triplestores. Semiodesk Trinity offers a Object-Mapping mechanism which also supports all the features that makes RDF great, for example being schema-less and inferencing.

The Microsoft SQL Server Data-Tier Application Framework (DacFx) is a component which provides application lifecycle services for database development and management for Microsoft SQL Server and Microsoft Azure SQL Databases. DacFx supports various database deployment and management scenarios for SQL Server and Microsoft Azure SQL Databases including extracting/exporting a live database to a DAC package, deploying a DAC package to a new or existing database, and migrating from on-premise SQL Server to Microsoft Azure. This functionality is exposed via the DacFx API. DacFx can target SQL Server 2008, 2008R2, 2012, 2014, 2016, 2017 and Microsoft Azure SQL Databases. This nuget package is a lightweight version of DacFx. If you would like to use the command-line utility SqlPackage.exe for creating and deploying .dacpac and .bacpac packages, please download DacFramework.msi from Microsoft download page.

Pure, fast and scalable .NET property graph and object hybrid database. No new graph language to learn, all accomplished with a .NET API.

Seq trace listener extension for System.Diagnostics, along with required config sections. Writes to the specified Seq server URL, with additional properties as configured. Other Essential.Diagnostics packages extend the .NET Framework System.Diagnostics trace logging with additional trace listeners. Included are colored console (that allows custom formats), SQL database (including a tool to create tables), rolling file (with custom formats), rolling XML, email (per trace or batched), and an in-memory trace listener. The Essential.Diagnostics project also publishes structured data (semantic) tracing extensions and a fluent client library that includes easy encapsulation of activity and logical operation scopes, as well as abstractions and templated classes for a simpler logging API and support for dependency injection frameworks. See the project site on GitHub for examples and documentation.

This is the initial SDK release for Amazon Timestream for InfluxDB. Amazon Timestream for InfluxDB is a new time-series database engine that makes it easy for application developers and DevOps teams to run InfluxDB databases on AWS for near real-time time-series applications using open source APIs.

A .NET implementation of the Amazon QLDB driver that can be used to programmatically access and interact with data in Amazon QLDB ledgers.

Fluent API for executing asynchronous database commands

Syncfusion Dashboard Encryption is a .NET standard library used to encrypt the user information such as database connection string, username, password for security purposes. This can be used while embedding ejdashboardviewer in any of the .NET application and while utilizing its API functionalities. Learn more: https://www.syncfusion.com/products/dashboard/viewer?utm_source=nuget&utm_medium=listing Documentation: https://help.syncfusion.com/dashboard-platform/dashboard-sdk/overview?utm_source=nuget&utm_medium=listing Support: Incident: https://www.syncfusion.com/support/directtrac/incidents/newincident?utm_source=nuget&utm_medium=listing Forum: https://www.syncfusion.com/forums/dashboard?utm_source=nuget&utm_medium=listing This is a commercial product and requires a paid license for possession or use. Syncfusion’s licensed software, including this component, is subject to the terms and conditions of Syncfusion's EULA (https://www.syncfusion.com/eula/dp/?utm_source=nuget&utm_medium=listing). To acquire a license, you can purchase one at https://www.syncfusion.com/sales/products?utm_source=nuget&utm_medium=listing or start a free 30-day trial here (https://www.syncfusion.com/account/manage-trials/start-trials?utm_source=nuget&utm_medium=listing). © Copyright 2019 Syncfusion, Inc. All Rights Reserved. The Syncfusion Dashboard Platform license and copyright applies to this distribution.

cloud4net is a framework to abstract cloud storage implementations, like ADO.net does for databases. Management tools are also provided.

Extensions to VelocityDB for efficient LINQ index/BTree queries, AzureSession file API usage with Microsoft Azure, import/export to/from CSV and JSON, Sync, GeoHash, Compressed Bitmap and RTree.