C# (CSharp) Platz.SqlForms StoreDefinition Examples

Example #1

File: SqlJsonStoreDatabaseDriver.cs Project: miguelbandera/MasterDetailsDataEntry

        public void CreateTable(string schema, StoreDefinition table)
        {
            var columns  = table.Properties.Values.OrderBy(p => p.Order).ToList();
            var pkColumn = GetPkColumn(columns[0]);

            var sql = @$ "
CREATE TABLE [{schema}].[{table.Name}] ({pkColumn}, {DATA_COLUMN} nvarchar(max));

Example #2

File: DataMigrationManager.cs Project: miguelbandera/MasterDetailsDataEntry

        private void GenerateTableScript(StringBuilder sb, StoreDefinition table)
        {
            sb.AppendLine($"CREATE TABLE {table.Name} (");

            foreach (var c in table.Properties.Values.OrderBy(v => v.Order))
            {
                var nullable  = c.Nullable ? "?" : "";
                var reference = "";
                var type      = c.Type;

                if (c.Fk)
                {
                    reference = $" FK {c.ForeignKeys[0].DefinitionName}.{c.ForeignKeys[0].PropertyName}";
                    type      = c.ForeignKeys[0].Type;
                }

                sb.AppendLine($"    {c.Name} {type}{nullable}{reference},");
            }

            sb.AppendLine(")");
        }