public string ColToSqlString(SColumn col, bool containidentity = true) { string templ = "{0} {1} {2} {3}"; string s = string.Format(templ, col.name, col.filedtype.ToSqlString(), col.allownull ? "null" : "not null", col.isidentity ? ("identity(" + col.identityattribute.send + "," + col.identityattribute.crement + ")") : "" ); return(s); }
public string ColToSqlString(SColumn col, bool containidentity = true) { string templ = "{0} {1} {2} {3} {4}"; string s = string.Format(templ, col.name, col.filedtype.ToSqlString(), col.allownull ? "null" : "not null", (containidentity && col.isidentity) ? ("AUTO_INCREMENT") : "", string.IsNullOrEmpty(col.description) ? "" : ("COMMENT '" + col.description.Replace("'", "\\'") + "' ") ); return(s); }