Location>code7788 >text

SQLSugar's Guide to Support TDengine Supertables

Popularity：232 ℃/2025-02-27 12:40:32

TDengine is a high-performance, distributed timing database, widely used in the Internet of Things, industrial Internet and other fields. One of its core concepts isSuper Table, which is similar to the table structure template in a traditional database, allowing users to dynamically create and manage subtables through tags (Tags). As a popular ORM framework, SQLSugar provides support for TDengine super tables, allowing developers to operate TDengine databases more conveniently.

This article will introduce how to use SQLSugar to operate the supertable of TDengine, including creating supertables, querying subtables, inserting data, etc.

1. Create a super table

Before using TDengine's supertable, you first need to create a supertable in the database. SQLSugar providesCodeFirstMode, the table structure can be automatically created through code.

NUGET installation

up to date
SqlSugarCore  Latest

Create a database object

//Add to the program when starting =
new [] { typeof(TDengineProvider).Assembly };

//db objectSqlSugarClient Db= new SqlSugarClient(new ConnectionConfig(){
ConnectionString = "Connection string",
DbType = ,
IsAutoCloseConnection = true});
 

// Create a super table<SUsingTagModel>();

In the above code,SUsingTagModelis an entity class that maps the supertable structure in TDengine. passMethod, SQLSugar will automatically create the corresponding super table in TDengine.

2. Define the supertable entity class

In SQLSugar, the entity class of the super table needs to be usedSTableAttributeTo mark and passSugarColumnto define field properties.

  
[STableAttribute(STableName = "SUsingTagModel", Tag1 = nameof(Tag1))]
public class SUsingTagModel
{
    [(IsPrimaryKey = true)]
    public DateTime Ts { get; set; }
    public bool Boolean { get; set; }
    public string Tag1 { get; set; }
}

  • STableAttributeUsed to mark this class as a super table.STableNameSpecify the name of the super table.Tag1Specify the tag field.

  • SugarColumnUsed to define field properties,IsPrimaryKeyIndicates that this field is the primary key.

3. Query super table data

SQLSugar providesAsTDengineSTableMethod, used to map query operations to TDengine's supertable.

Query all data

var list1 = <SUsingTagModel>().AsTDengineSTable().ToList();

Query specific subtable data

passWhereConditions can query the subtable data of a specific tag.

// Query subtable Avar tagA = &lt;SUsingTagModel&gt;().AsTDengineSTable().Where(it =&gt; it.Tag1 == "a").ToList();

// Query subtable Bvar tagB = &lt;SUsingTagModel&gt;().AsTDengineSTable().Where(it =&gt; it.Tag1 == "b").ToList();

4. Insert data and create subtables dynamically

When inserting data, SQLSugar supports dynamic creation of subtables based on label values. passSetTDengineChildTableNameMethod, you can specify the naming rules of the subtable.

(new List<SUsingTagModel>(){
    new SUsingTagModel()
    {
        Boolean = true,
        Tag1 = "a",
        Ts = (1)
    },
    new SUsingTagModel()
    {
        Boolean = true,
        Tag1 = "b",
        Ts = (3)
    }
})
.SetTDengineChildTableName((stableName, it) => $"{stableName}_{it.Tag1}")
.ExecuteCommand();

  • SetTDengineChildTableNameMethods are used to specify the naming rules of subtables.stableNameis the name of the super table.itis the currently inserted data object.

  • ExecuteCommandThe method performs an insert operation and automatically creates a subtable.

5. Dynamically map supertable names

In some scenarios, the name of the super table may need to be dynamically modified. SQLSugar providesMappingSTableNameMethod, which can dynamically map supertable names at runtime.

<SUsingTagModel>("newSName001");

  • MappingSTableNameMethods are used to dynamically modify the name of the super table and replace the entity class.STableAttributeofSTableNameAttributes.

6. Summary

Through SQLSugar's support for TDengine supertables, developers can operate TDengine databases more conveniently. This article describes how to create supertables, query subtables, insert data, and dynamically map supertable names using SQLSugar. These functions make SQLSugar a powerful tool for processing TDengine data, especially suitable for timing data processing scenarios such as the Internet of Things and the Industrial Internet.

In actual development, developers can flexibly use these functions according to business needs to improve development efficiency and optimize database operation performance.

<Previous