IoTSharp.EntityFrameworkCore.Taos
An ADO.NET provider for TDengine supporting native, WebSocket, and RESTful protocols with Schemaless and Stmt features.
What is IoTSharp.EntityFrameworkCore.Taos?
IoTSharp.Data.Taos is an ADO.NET provider for the TDengine time-series database, allowing .NET applications to connect and interact with TDengine using native, WebSocket, or RESTful protocols. It solves the problem of efficient data access and manipulation in IoT and time-series applications by providing features like Schemaless bulk inserts and parameterized statements.
.NET developers building IoT platforms, time-series data applications, or systems that require high-performance data ingestion and querying with TDengine.
Developers choose this provider for its multi-protocol flexibility, performance-optimized bulk operations, and seamless integration with the .NET ecosystem, including Entity Framework Core and ASP.NET Core health checks.
Overview
ADO.NET, ORM,Stmt,TDengine
Use Cases
Best For
- Building IoT data platforms that require high-volume time-series data ingestion
- Migrating InfluxDB-based applications to TDengine with compatible data formats
- Developing .NET microservices that need efficient database connectivity to TDengine
- Implementing parameterized queries for secure and performant database operations
- Integrating TDengine with ASP.NET Core applications including health monitoring
- Creating data access layers for time-series analytics in C# applications
Not Ideal For
- Applications requiring full feature support over RESTful protocol (no Schemaless or parameterized statements)
- Projects heavily dependent on Entity Framework Core for ORM due to deprecated EF Core package
- Environments where installing native TDengine client libraries (libtaos) is restricted or complex
- Simple CRUD applications without high-volume time-series data ingestion needs
Pros & Cons
Pros
Supports Native, WebSocket, and RESTful protocols, allowing deployment in environments without native dependencies (e.g., WebSocket is pure C#).
Implements Schemaless for TSDB_SML_LINE_PROTOCOL and TSDB_SML_JSON_PROTOCOL, enabling high-performance data ingestion compatible with InfluxDB formats.
Provides Stmt for prepared statements, enhancing security by preventing SQL injection and optimizing query execution.
Compatible with TDengine Cloud services and self-hosted deployments, with configurable connection strings for diverse setups.
Includes ASP.NET Core health checks and ADO.NET provider, though EF Core integration is deprecated.
Cons
The IoTSharp.EntityFrameworkCore.Taos package is explicitly noted as deprecated, limiting ORM-based development and future compatibility.
RESTful protocol lacks support for Schemaless bulk inserts and parameterized statements, reducing functionality compared to other protocols.
Using Native protocol requires installing the TDengine client library (libtaos), adding setup complexity and potential cross-platform issues.
README provides basic examples but lacks detailed guides for complex scenarios like large-scale deployments or troubleshooting.
Frequently Asked Questions
Related Projects
APIJSON🏆 Real-Time no-code, powerful and secure ORM 🚀 providing APIs and Docs without coding by Backend, and Frontend(Client) can customize response JSONs 🏆 实时 零代码、全功能、强安全 ORM 库 🚀 后端接口和文档零代码，前端(客户端) 定制返回 JSON 的数据和结构
sqliorm sql query builder, API: QB, QB.X, QrB
crowncrown is a simple and small ORM forTDengine(TSDB)
tdengine-orm基于 tdengine-restful-connector、php-tdengine 开发的 TDEngine ORM。
Found a gem we're missing?
Open-Awesome is built by the community, for the community. Submit a project, suggest an awesome list, or help improve the catalog on GitHub.