Database-neutral migration plan (ADR-0060, ADR-0081): SQL scripts (embedded V{version}__/R__ discovery, SHA-256 checksums over line-ending-normalized content) and C# ICodeMigration steps — and, through Elarion.Migrations.EntityFrameworkCore, EF Core migrations — merged into one version-ordered sequence with one history table and one exclusive lock. Out-of-order and repeatable planning, satisfied/baseline adoption, and the roll-forward execution model (a step's history row commits with its transaction — no repair command, no failed-row limbo). Drives a database provider through the IMigrationDatabase seam and the neutral AddElarionMigrations over an IMigrationDatabaseFactory a provider registers (Elarion.Sql.PostgreSql, Elarion.Sql.Sqlite). NativeAOT-compatible; contains no database driver and no EF reference.
Bogus generators (fake data generators) for ready-to-use strong types to strongly-type your interfaces (properties, methods, APIs, DB entities, appsettings). Eliminate stringly-typed interfaces. Make compiler your friend, introduce semantics to your code.
Library for quickly and easily accessing sql data via JSON, service endpoint, or code-gen
BulkDataSeeder.EfCore is a versatile library that simplifies the process of seeding data into multiple database systems using Entity Framework Core. It supports SQL Server, MySQL, and PostgreSQL, making it an ideal choice for projects with diverse database requirements.
StorageProvider to store Data on a REDIS Server.
In-memory range and multirange types for .NET 10, mirroring PostgreSQL's six built-in range domains (int4range, int8range, numrange, daterange, tsrange, tstzrange) plus TimeRange over TimeOnly — the time-of-day range PostgreSQL users conventionally add as CREATE TYPE timerange AS RANGE (subtype = time), and Float64Range and Float32Range over finite double and float (the custom float8range and float4range). Each type is a discriminated union of five sealed variants (Finite, UnboundedStart, UnboundedEnd, EmptyRange, Infinity) with invalid states unrepresentable at compile time. Includes the full PostgreSQL interval algebra — Contains, Overlaps, IsAdjacentTo, Intersect, Union, Except, Complement, Merge (range_merge), bound accessors (lower/upper/lower_inc/upper_inc), the RangeAgg/RangeIntersectAgg aggregates, Gap/Gaps, Shift/Expand, Split, the Month/Quarter/Year/IsoWeek calendar factories and IComparable in PostgreSQL's range order — plus RangeSet<TRange, T> as an immutable, always-normalized multirange with the complete multirange operator matrix. v6 adds value sets: immutable, canonical (deduplicated, sorted, null-free) sets of scalar values whose PostgreSQL storage shape is a native array — StringSet (text[]), GuidSet (uuid[]), Int16Set/Int32Set/Int64Set, DecimalSet, Float64Set (double precision[]), Float32Set (real[]), DateSet, TimeSet, DateTimeSet, DateTimeOffsetSet — plus a validated-wrapper arity for every one of them (StringSet<T>, GuidSet<T>, Int16Set<T>, Int32Set<T>, Int64Set<T>, DecimalSet<T>, Float64Set<T>, Float32Set<T>, DateSet<T>, TimeSet<T>, DateTimeSet<T>, DateTimeOffsetSet<T>) for Vogen/Metalama/StronglyTypedId-style domain values, constrained only on BCL interfaces. Membership algebra (Contains, Overlaps, IsSubsetOf, IsSupersetOf, Union), PostgreSQL array literals, and collection expressions included. All types implement IParsable<T> and IFormattable using PostgreSQL literal syntax, and ship with System.Text.Json converters for direct use in ASP.NET Core APIs. No database dependency.
Msb.DatabaseContext is a lightweight, attribute-driven ORM for .NET that enables automatic CRUD operations, function and stored procedure execution, JSON mapping, and transaction management across all major relational databases (RDBMS).
StorageProvider to store Data on RethinkDB.
Library containing model classes to use with the Code Generator JSON input type. Code Generator has multiple input providers, like assembly readers, json, or database schemas. If you want to provide json to feed the tool, please use the models in this library.
This package can be used in your websites, where you want to create simple login systems without having to install and manage the databases. It makes use of JSON files and simple .NET code to create and expose methods to create accounts, let them log in and log out. You can use the UserId and other details of the users to create other dynamic objects too.
Oooops!Simple, simple-to-call approach, integration of multiple platforms, multiple environments!简单的、傻瓜式的调用方式,集成多平台、多环境!: This is an ASP.NET help class written in C#,which organized a lot of open source code,a lot of good authors and source code are referenced. The original purpose is to collect the various problems that have been encountered in development, and organize them into knowledge base, which can facilitate the development and learning of the future. The main functions of this help library are: File processing, log system, form transition, JSON, XML, parse, circuit breakers, retry mechanism, ZIP compression/decompression, Winform beautification, multi-thread calls, add and delete registry, mainstream database to add and delete, thread the fuse/kill, batch command/command-line execution, HTTP, string formatting, sentenced to services and service request Break, MD5, AES, DES, RSA, BASE64 and other encryption algorithms and other practical functions. The class library supports multiple versions (.net Framework 4.5~4.8/.NET5.0~6.0/.NET Core 3.1/.NET Standard2.0~2.1). To prevent code abuse, the library has its own signature verification mechanism, and the code needs to run on the signed machine.Future will continue to fill in various useful help library. The signing machine download please email:1924038917jsa@gmail.com or attention:https://github.com/GHjiaoshouang. If there is infringement please contact me. Thanks. `简单的、傻瓜式的调用方式,集成多平台、多环境! `这是基于C#语言开发的ASP.NET帮助库,里面整理了很多开源的代码,借鉴了很多优秀作者的代码。最初目的是用于搜集自己在开发当中遇到的各种问题,整理成知识库,便于以后的开发和学习。主要的功能有:文件处理、日志系统、表格转换、JSON解析、XML解析、断路机制、重试机制、ZIP压缩/解压缩、Winform美化、多线程调用、注册表增删改查、主流数据库增删改查、线程熔断/强杀、批命令/命令行执行、HTTP服务及服务请求、字符串格式化、判断、MD5/AES/DES/RSA/BASE64等多种加密算法等多种实用功能。类库支持多个版本(.NET Framework 4.5~4.8/.NET5.0~6.0/.NET Core 3.1/.NET Standard2.0~2.1)。 `如果使用过程中遇到问题,可以在【https://github.com/GHjiaoshouang/JSAHelpTest.git】查看具体的调用和使用方式。 `为了防止代码滥用,类库设有专属的签名验证机制,代码运行需要在已被签名的机器上。后期会不断向里面填充各类实用帮助类库。签名器关注GitHub:[https://github.com/GHjiaoshouang]。如有侵权请联系我。 `谢谢。
PgOutput2Json.RabbitMqStreams library uses PostgreSQL logical replication to push changes, as JSON messages, from database tables to RabbitMQ Streams
Common Utilities Used For Project. 1.The Utils class offers helper functions for string manipulation, data conversion, configuration retrieval (Appsettings and Web.Config), encryption (SHA-256) and MD5, formatting (currency, date), and standardized response handling and also handleException using log4Net. 2.The RestExtension class extends HttpClient, providing async methods for GET, POST, and PATCH requests. It handles headers, request creation, response deserialization, and error handling via ApiResponse. It supports JSON, lists, and binary data (PDFs) with cancellation tokens to prevent long-running requests. Potential improvements include strongly typed models, better logging, and optimized header management. 3.The Logs class manages structured logging for security (SIEMLogs), exceptions, and API requests. It dynamically creates log files, ensures directory existence, sets access permissions, and timestamps entries for monitoring, debugging, and auditing. 4.DataServiceUtils provides async methods for executing SQL queries using SqlConnection. It includes GetScalarAsync for fetching a single value and ExecuteNonQueryAsync for non-query commands, both supporting optional SQL parameters. It ensures resource management and preserves exception stack traces, but CommandTimeout = 0 may cause indefinite waits. 5.MongoDataServiceUtils is a utility class that provides asynchronous CRUD operations for MongoDB. It includes methods for inserting (InsertDocumentAsync), updating (UpdateDocumentAsync), retrieving (GetDocumentsAsync), and deleting (DeleteDocumentAsync) documents based on filter criteria. Additionally, it offers a synchronous method (CountDocuments) to count documents in a collection. This class simplifies MongoDB interactions by providing reusable and efficient database operations. FileLogger Class :- The FileLogger class provides a simple method to log informational messages to a specified file path. The static method LogInformation takes a message and a logging path as input. It first checks whether the directory for the log file exists; if it doesn't, the method creates the directory. Then, it appends the message to the log file, prefixed with the current timestamp. The method includes basic exception handling to avoid application crashes due to any file I/O errors, although the catch block is currently empty and does not log or rethrow the exception.
Use this SDK to avoid having to use Entity Framework (EF) and simplify your time to code complete. This library is built along the familiar lines of my Azure Tables package. Use the attributes from the 'SujaySarma.Data.SqlServer.Attributes' namespace to decorate your business object classes/records/structs and their properties and fields. The 'SqlTableContext' is your starting point for firing any DML or query operations. To debug query generation, use the methods in the 'SQLScriptGenerator' class -- the outputs of these functions are used in the DML operations.
Straightforward database for .NET applications which helps you store data with minimal overhead.
A client library for BlueDB library. Includes base classes for entities and supports JSON encoding/decoding of entities.
The VersaTul Collection Streamers provides functionality that enables developers to quickly convert a collection of objects in memory into a data-reader that can be used for Bulk inserting data into a SQL Database, or be used to generate flat files. Developers can use the streamers to: 1. Convert a Collection to a Data-Reader. 2. Convert from a Data-Reader to other file formats such as CSV, TAB or Json. 3. Compress converted data into Zip files. 4. Transport the converted data via e-mail. The Streamers project also works with Display Attributes which is used to manipulate the properties on the objects in the collection such as formatting the data or renaming the property with a desired display name.
This is the SAP HANA connector for ETLBox. It integrates with SAP HANA databases, enabling high-performance data processing and analytics. 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/
StorageProvider to use SQLCache as Data-Store. Note: SQLCache is not a long term storage as the items will expire after 30days (default value)
A library to serialize models in a relational database as non-relational serialized objects with Json (by default), and implementing the Unit of work pattern. It "hooks" with entity framework (but could be used in the future with other ORM's)
This package can be used in combination with the ZigBeeNet package and is a JSON data store implementation for your devices
Provides implementation of sessions and factories using Marten library.
PgOutput2Json.Kafka library uses PostgreSQL logical replication to push changes, as JSON messages, from database tables to Kafka
Lightweight and highly opioninated NoSQL database written on top of SQLite
仅供内部使用,内涵特殊加密方式 For internal use only, with special encryption built in.This is an ASP.NET help class written in C#,which organized a lot of open source code,a lot of good authors and source code are referenced. The original purpose is to collect the various problems that have been encountered in development, and organize them into knowledge base, which can facilitate the development and learning of the future. The main functions of this help library are: File processing, log system, form transition, JSON, XML, parse, circuit breakers, retry mechanism, ZIP compression/decompression, Winform beautification, multi-thread calls, add and delete registry, mainstream database to add and delete, thread the fuse/kill, batch command/command-line execution, HTTP, string formatting, sentenced to services and service request Break, MD5, AES, DES, RSA, BASE64 and other encryption algorithms and other practical functions. The class library supports multiple versions (.net Framework 4.5~4.8/.NET5.0~6.0/.NET Core 3.1/.NET Standard2.0~2.1). To prevent code abuse, the library has its own signature verification mechanism, and the code needs to run on the signed machine.Future will continue to fill in various useful help library. The signing machine download please email:1924038917jsa@gmail.com or attention:https://github.com/GHjiaoshouang. If there is infringement please contact me.
A library for creating a couch app design document. (to be used with CouchN but you could hook it up standalone) The code uses node.js to run any "*_design.js" documents in the project and convert them to "*_design.json" (where * is the name of your design doc) Once the json document has been created you should make it an embedded resource for the project. Then you can have your main project update design documents in couch with a one liner. ** NOTE ** you need to include the CreateDesignDoc.targets into your projects *.proj file. Just open it in nodepad and enter this line near the botton: <Import Project="CreateDesignDocs.targets" /> TheCouch.SetupDatabaseAndDesignDocuments<DesignDocuments>("MyDb", "http://thecouchdb:5987"); This will create a new database "MyDb" if it doesn't exist and then upload the design documents embbed in the assembly which contans the "DesignDocuments" type.
This project is a middleware allowing to build automatically a complete RESTful API that will pick its data via CRUD operations in a database. All database requests and Swagger documentation are generated based upon a description stored in database or json file.
Mini-Biggy is a Very Fast Document/Relational Query Tool with Full LINQ Compliance. This package adds storage for SqlServer.
A .NET Client for the https://sqlizer.io API. SQLizer lets you easily and securely convert Excel, JSON, CSV and other files into SQL databases with table definitions and multiple INSERT statements. We're free for non-commercial use on files with under 5000 rows of data and our paid plans enable you to use our powerful API to build data pipelines that handle billions of rows a day.
请在最终运行的项目中配置服务端参数,文件名规则为:*.cloud.server.config.json,以下为参考配置: { //协议配置,可以是单个对象,或数组 //可以不填写 "protocol": [ { //名称,可以不填写 "name": "default", //数据,不填写默认为json "data": { //类型:json,xml,treePackage,soap,custom "type": "json", //自定义格式类型:TestAssembly.TestClass, TestAssembly //可以不写 "customType": null }, //加密,不填写默认不加密 "encrypt": { //类型:none,AESStatic,custom "type": "none", //自定义格式类型:TestAssembly.TestClass, TestAssembly //可以不写 "customType": null }, //传输介质,不填写默认为original "media": { //类型:original,base64,hex,custom "type": "original", //自定义格式类型:TestAssembly.TestClass, TestAssembly //可以不写 "customType": null } } ], //服务器 "server": { //名称,可以不填写 "name": "my.cloud", //主机:域名或IP,默认localhost "host": "localhost", //端口 "port": 10086, //超时:秒,默认120,可以不写 "timeout": 120, //调试模式:默认不启用,可以不写 "debug": true, //参数设置:可以不写 "settings": { } }, //数据库,不需要可以不写 "database": { //连接参数 //通用参数:主机、端口、数据库名称、账号、密码 //其它参数可以写在里面,取决于提供者是否支持 "connection": { //host 主机,可以包括端口,经test.com:1433 "host": "localhost", //port 端口,可以不写,表示默认 "port":11433, //name 数据库名称 "name": "test", //account 账号 "account": "test", //password 密码 "password": "123456" } }, //客户端 "client": [ { //名称,可以不写,并没有影响 "name": "my.manager", //状态 "enable": true, //授权码 "authCode": "203AFBA5816078A7BAF822C04687B3D3", //权限列表,可以不写 "permissions": [ ], //外部配置,可以不写 //可以为单个字符串,或数组 //外部配置可重写 authCode //外部配置可追加(自动去重) permissions //路径相对于配置文件 //支持变量 {name} {server.name} "config": [ "module.*.manager.client.json", "{server.name}.manager.client.json" ] } ] } 请在api项目中配置权限信息,命名规则以服务端配置config规则定义为准,以下为示例配置: 文件名:module.setting.manager.client.json { "permissions": [ //系统设置.Begin "my.read.setting", "my.write.setting" //系统设置.End ] }
Goodbye WordPress is a customizable library and command line tool for exporting posts from a WordPress MySQL database to static Markdown or HTML files, with YAML front-matter for metadata preservation. It is intended as a starting point for migrating away from a WordPress blog to a static site. It further supports saving images referenced in the original posts and can generate a single-file archive of all exported posts in JSON format, in case the export process needs to run again after the MySQL database has been taken down. Note, there is a .NET command line tool ("goodbye-wordpress") available for simple export, but the library allows heavy customization through overriding pieces of the export pipeline in WordPressExporterDelegate.
A JSON document database layer built on top of PostgreSQL. Store, query, and subscribe to JSON documents — with PostgreSQL as the storage backend via JSONB.
Provider-agnostic data access for ClrKernel: an ergonomic C# query API (connect → Query(sql).Results()/.Results<T>() → interactive grid + dynamic rows), a secret-free connection/secret store (OS credential managers, env-var fallback), and JSON config-file connection definitions. The shared core beneath ClrKernel.Database.Provider.SqlServer and the ClrKernel.Database.* database providers (Oracle, ODBC, JDBC).
Common files for PostgreSQL and SQLite document database libraries