SqExpress is for those who like SQL but hate raw strings. It lets you build SQL directly in C# with strong typing and IntelliSense, while keeping the code close to real SQL and avoiding LINQ translation. Key features: - Strongly typed SQL AST with export to MS T-SQL, PostgreSQL, MySQL, and SQLite - Cross-dialect JSON extraction, construction, mutation, array-to-table expansion, and relational JSON output - Complex query building with joins, subqueries, CTEs, set operators, analytic/window functions, and MERGE-style workflows - Syntax tree traversal and modification for dynamic query scenarios - T-SQL parser (`SqTSqlParser`) for importing supported SQL into SqExpress AST - Fail-closed validation and security-predicate rewriting workflows for AI-generated T-SQL within the supported parser surface - T-SQL to SqExpress transpilation, analyzer support, and code fixes - Table descriptors, create/drop script generation, and DTO/SqModel generation - Database-first scaffolding for table descriptors and models - Table descriptor generation from Entity Framework models - Live database metadata retrieval and table-list comparison with flags-based diff/inclusion helpers - Foreign-key graph navigation and join-path discovery with `TablesGraph` - Lightweight ADO.NET-based data access for MS SQL Client, Npgsql, MySQL connectors, and Sqlite SqExpress works well for both code-first and database-first workflows. Here's an article that explains the library principles: ["Syntax Tree and Alternative to LINQ in Interaction with SQL Databases"](https://itnext.io/syntax-tree-and-alternative-to-linq-in-interaction-with-sql-databases-656b78fe00dc?source=friends_link&sk=f5f0587c08166d8824b96b48fe2cf33c)
[.NET Standard 2.0]AutoCSer is a flexible and versatile high-performance RPC framework that is a distributed application infrastructure framework. AutoCSer based on the implementation of support reliable persistence and object-oriented programming memory database, high concurrency throughput performance is much higher than Garnet + StackExchange.Redis, support according to the business logic to customize any data structure node, Supports the local embedding mode to meet the needs of high-performance game intra-office services.
PgOutput2Json library uses PostgreSQL logical replication to push changes, as JSON messages, from database tables to any .NET application
Detects MIME type based on file content or file extension
Object / Document peer to peer database for the .NET framework.
Provides ability to track changes to data models through watching changes to the selected instances. You are able to determine if the entities have changes to properties, new items have been added or when an item has been deleted. The framework allows you to batch processing of changes and perform updates in single operations. It provides similar functionality to the Micrsoft EntityFramework but on a much lighter basis and without any database component. The framework was specifically designed for Blazor where the data is sent to the client using JSON serialization and then changes are made which need to be sent back to the server in batches.
Client API needed to interact with the ElephantSqlDB cloud database storage services. If your application requires cloud storage of unstructured JSON or key/value paired data, the ElephantSqlDB client is an affordable and extremely fast alternative to any of the following solutions: 1. ActiveMQ 2. AWS DynamoDB 3. Azure CosmoDB 4. Google Cloud Datastore 5. Oracle NoSQL Database 6. PostgreSQL 7. MongoDB 8. RavenDB 9. Redis 10. Supabase 11. Couchbase
This tool will help you to check your FetchXML results easly :) 1- You can run FetchXML query and show results into a clear view grid. 2- You can convert and run a SQL Select statment on CRM directly. 3- You can run an on-demand workflow against all selected records. 4- You can run and export data on the fly to Csv file. 5- You can run and export data on the fly to Sql server Database. 6- You can run and export data on the fly to Json file. 7- format and copy the XML to use it directly in C#. 8- Generate a C# class based on FetchXML query. 9- You can write C# script to run it against result set.
Komodo core libraries for crawling (file, object, web, database), parsing (JSON, XML, SQL, Sqlite, HTML, text), postings (inverted index, token extraction), indexing (search), metadata generation, and integrating within your application. Komodo is an information search, metadata, storage, and retrieval platform.
EasyDocDb - embedded nosql document persistance for .NET Core.
FileStorage is a document database stored in file system. Documents stores in various formats: json, csv, etc.
A simple command-line tool for get useful database information (in json format). Supported ones: Microsoft SQL Server, AWS DynamoDb, Azure CosmosDb, MongoDb
Versioned YAML and JSON schema documents for DubUrl.
Fenrir is a service testing framework that load tests, stresses, and compares results of micro-services. Requests are generated from data sources (web-service, database, flat file, etc.) or predefined in json following comparable request format. It supports image, json, xml, and text comparison targets. It is meant to be flexible and to be integrated into development pipelines. This is the dotnet tool.
Lightweight database mapping library for .NET. Maps DbDataReader rows to CLR objects with automatic snake_case to PascalCase column mapping, constructor-based entity creation, custom type handlers, and enum support.
FileContext is a data access layer (DAL) Framework for rapid data driven application development (RDDAD) append to EntityFramework.
StorageProvider to store Data on Azure Blob
StorageProvider to use FileSystem as Data-Store.
This is the IBM Db2 connector for ETLBox. It allows you to connect to IBM Db2 databases and handle relational data for integration, migration, and reporting. ETLBox is a complete ETL (Extract, Transform, Load) library and data integration toolbox for .NET. # Build scalable, code-first ETL pipelines for SQL, NoSQL, APIs, and flat files. # Automate data movement, transformation, and synchronization with minimal memory usage. # Ideal for data warehousing, migrations, and big data processing. Simplify your data integration workflow: ETLBox enables efficient, asynchronous data processing by reading from databases, APIs, and file formats like CSV, Excel, and JSON. Transform data dynamically with row-based, batch, or lookup transformations, and read or write from/to multiple destinations in parallel. Key Features: * Stream large datasets efficiently without loading everything into memory * Maximize performance with parallel, task-based data flow execution * Connect to various data sources with built-in connectors or extend with custom components For tutorials, examples, and documentation, visit: https://www.etlbox.net/
Json Serializer for EasyDocDb - stores documents as JSON files.
SemanticLogging.Database.Xml is a sink for the Semantic Logging Application Block that exposes Event Source events to an Sql Server database. The default database sink uses a Json document to store the payload data whereas this sink uses an xml document to store the payload data.
It is very similar to Microsoft.Extensions.Configuration.Json. The only difference is that instead of using a appsettings.json file with `AddJsonFile()`, you can use your own Repository with `AddJsonRepository()`. Your JSON Repository can provide the data from any internal/external source(s) including SQL/NoSQL Database calls, API calls, etc.
NFX.Wave Web Server Framework Package NFX UNISTACK includes: Application Container + Dependency Injection facilities Configuration engine BigMemory: Local/Distributed piles/heaps, ability to store hundreds of millions of objects resident in memory for long times without killing GC BigMemory Cache - store hudreds of millions of objects in RAM without GC pressure (full GC scan <20ms @ 300M+ objects 64 Gb taken) Logging with 8+ destinations/sinks(text, email, flood filter etc.) Distributed contact-oriented communication framework NFX.Glue (replaces WCF) Security with users, credentials, roles, permissions JSON parsing, ser/deser support Ultra efficient Binary serialization support Erlang CLR support with native types: tuples, lists, pattern matching Text lexing/parsing and processing pipeline: C# lexer, JSON lexer/Parser RelationalSchema language compiler - generate DDL for different targets Templatization engine (for web, emails and not only textual content) NFX.WAVE - Web Server with hybrid injectable threading model (replaces IIS + ASP.NET) NFX.WAVE.Mvc - MVC framework for web pages WV.js - a web component library auto-bindable to server MVC/MVVM Database access layer with virtual commands/queries/transactions ID generation - GlobalDistributed IDS (GDID), FID - fast process-wide ID Virtual Social Network - Twitter/Facebook/Google+ et al Virtual Payment Processing - Stripe,PayPal providers Virtual File Systems - AmazonS3, SVN, Local QR Code Creation In progress: Virtual document model with rendering to PDF, HTML and other formats In Progress: PDF DOM model + rendering
A simple object store library to persist objects for demo and testing applications. The objects will be serialized to JSON and stored on the file system by default.
StorageProvider to store Data in Memory.
AutoCSer is a distributed application infrastructure framework implemented in C#. Its core is a full-duplex RPC component based on TCP long connections, featuring high concurrency, high throughput and other high-performance characteristics. AutoCSer based on the implementation of support reliable persistence and object-oriented programming memory database, high concurrency throughput performance is much higher than Garnet + StackExchange.Redis, support according to the business logic to customize any data structure node, Supports the local embedding mode to meet the needs of high-performance game intra-office services.
DapperMapper will ease your Data Management in Microsoft SQL SERVER and and Sqlite with the same interface. We provide Bulkinsert from JSON file in the package named "JSONAM" ease as one line of code to insert millions record to the supported database.
NFX MySQL Provider Package NFX UNISTACK includes: Application Container + Dependency Injection facilities Configuration engine BigMemory: Local/Distributed piles/heaps, ability to store hundreds of millions of objects resident in memory for long times without killing GC BigMemory Cache - store hudreds of millions of objects in RAM without GC pressure (full GC scan <20ms @ 300M+ objects 64 Gb taken) Logging with 8+ destinations/sinks(text, email, flood filter etc.) Distributed contact-oriented communication framework NFX.Glue (replaces WCF) Security with users, credentials, roles, permissions JSON parsing, ser/deser support Ultra efficient Binary serialization support Erlang CLR support with native types: tuples, lists, pattern matching Text lexing/parsing and processing pipeline: C# lexer, JSON lexer/Parser RelationalSchema language compiler - generate DDL for different targets Templatization engine (for web, emails and not only textual content) NFX.WAVE - Web Server with hybrid injectable threading model (replaces IIS + ASP.NET) NFX.WAVE.Mvc - MVC framework for web pages WV.js - a web component library auto-bindable to server MVC/MVVM Database access layer with virtual commands/queries/transactions ID generation - GlobalDistributed IDS (GDID), FID - fast process-wide ID Virtual Social Network - Twitter/Facebook/Google+ et al Virtual Payment Processing - Stripe,PayPal providers Virtual File Systems - AmazonS3, SVN, Local QR Code Creation In progress: Virtual document model with rendering to PDF, HTML and other formats In Progress: PDF DOM model + rendering
Command line tool to clone/build/run templates, or create dbschema models (extract schema from MSSQL/PostgreSQL database into json files)
File based database provider for Entity Framework Core (for development purposes)
PgOutput2Json.RabbitMQ library uses PostgreSQL logical replication to push changes, as JSON messages, from database tables to RabbitMQ
DataBind is a simple javascript function that facilitates binding Data from a JSON object to a HTML template. The objective of this script is to enable using templates without introducing any new or invalid syntax and without dictating the way you structure your application. All you need is a single function. Documentation: https://databind.codeplex.com/documentation
C# .Net Code Generator designed to generate the following assets based on a C# Interface: * SQL Server 2016 Stored Procedures for CRUD activiity * Repository code for converting raw JSON to concrete implementations of C# Interface * Model code which is the concrete implementation of C# Interface * Business Library allowing for business rules to be applied to data in concrete implementation of C# Interface * Stubbed WebApi endpoints C# .Net Code Generator allows you to spend your time in the following areas: * crafting stored procedures to surface database data matching the data needs imposed by a C# Interface * crafting your business rules in a single location * crafting WebApi endpoints (you can use code generated samples as a starting point) * crafting your front-end experience C# .Net Code Generator requires the following projects in .Net Solution: * Business Library (housing business rules applied to data in concrete implementaitons of C# Interfaces) * Data Contracts (housing C# Interfaces) * Models (housing concrete implementaitons of C# Interfaces) * Repository (housing calls to database and translation to concrete implementaitons of C# Interfaces) * WebAPI (housing API controllers) Utilizing this code generator increases your productivity and produces consistent, reliable results
NFX WinForms Package NFX UNISTACK includes: Application Container + Dependency Injection facilities Configuration engine BigMemory: Local/Distributed piles/heaps, ability to store hundreds of millions of objects resident in memory for long times without killing GC BigMemory Cache - store hudreds of millions of objects in RAM without GC pressure (full GC scan <20ms @ 300M+ objects 64 Gb taken) Logging with 8+ destinations/sinks(text, email, flood filter etc.) Distributed contact-oriented communication framework NFX.Glue (replaces WCF) Security with users, credentials, roles, permissions JSON parsing, ser/deser support Ultra efficient Binary serialization support Erlang CLR support with native types: tuples, lists, pattern matching Text lexing/parsing and processing pipeline: C# lexer, JSON lexer/Parser RelationalSchema language compiler - generate DDL for different targets Templatization engine (for web, emails and not only textual content) NFX.WAVE - Web Server with hybrid injectable threading model (replaces IIS + ASP.NET) NFX.WAVE.Mvc - MVC framework for web pages WV.js - a web component library auto-bindable to server MVC/MVVM Database access layer with virtual commands/queries/transactions ID generation - GlobalDistributed IDS (GDID), FID - fast process-wide ID Virtual Social Network - Twitter/Facebook/Google+ et al Virtual Payment Processing - Stripe,PayPal providers Virtual File Systems - AmazonS3, SVN, Local QR Code Creation In progress: Virtual document model with rendering to PDF, HTML and other formats In Progress: PDF DOM model + rendering
StorageProvider to forward all uploads to another jaindb URL. Note: This provider does not provide any query/reporting options.
Operate databases(servers) like file system on the disk sqlcon command: dir,cd,md,rd,del,type,ren,copy,comp,xcopy,cls,ver,echo,rem,set,import,export,mount,umount,open,save,edit,clean,execute,attrib Support SQL Server, LocalDB, SQL Azure, SQL Server Express Support Xml database on disk or web/ftp site which is used to compare database on 2 differnet networks. Support unlimited database server connections Compare data/schema between 2+ databases or database servers, and generate SQL script Copy data/schema between 2+ databases or database servers Search data rows, column, table, view, proc and database name by wildcard(*,?) Edit data on GUI or console Clean redundant rows Delete rows with constraints Generate data in format of json, CSV, and SQL script Generate C# class: data contract, Linq to SQL, and entity framework Execute SQL Script file Support all SQL statements
A .net core database client library that includes ORM functions, JSON support and more.
Enables the persistence of objects to and from various mediums, such as databases, XML, JSON, etc..
StorageProvider to store Data on CosmosDB.