using SYSModel.SQLObj; TableInfo myTable = new TableInfo("MyTable"); myTable.AddColumn(new ColumnInfo("ID", DataType.INT32, true, true)); // Primary key column myTable.AddColumn(new ColumnInfo("Name", DataType.STRING, 50)); myTable.AddColumn(new ColumnInfo("Age", DataType.INT32)); myTable.CreateTable();
using SYSModel.SQLObj; TableInfo myTable = new TableInfo("MyTable"); QueryInfo selectQuery = new QueryInfo(); selectQuery.SelectColumns.Add("Name"); selectQuery.SelectColumns.Add("Age"); selectQuery.Condition = new Condition("Age", Operators.GREATER_THAN, 18); ListIn summary, SYSModel SQLObj is a package library in C# that provides an object-oriented interface for working with SQL databases. It includes classes for creating tables, running queries, and updating data.results = myTable.Select(selectQuery);