Ejemplo n.º 1
0
        public virtual bool CreateTable(IFreeDocument example, string name)
        {
            if (string.IsNullOrEmpty(name))
            {
                throw new Exception(GlobalHelper.Get("key_29"));
            }
            FreeDocument txt = example.DictSerialize(Scenario.Database);
            var          sb  = string.Join(",", txt.Select(d => $"{ ScriptHelper.RemoveSpecialCharacter(d.Key)} {DataTypeConverter.ToType(d.Value)}"));
            string       sql = $"CREATE TABLE {GetTableName(name)} ({sb})";

            ExecuteNonQuery(sql);
            RefreshTableNames();
            return(true);
        }