protected string DbNullAndDefault(TableFieldDefInfo fieldInfo) { if (fieldInfo == null) { return(DBConstants.EMPTY_STRING); } bool bColumnDefault = DbColumnDefault(); bool bFieldDefault = (fieldInfo.m_strDefaultValue.Length != 0); bool bRequiredDefault = DBPlatform.DefaultBindRequired(fieldInfo.m_lAttributes); bool bAutoIncremField = ((fieldInfo.m_lAttributes & DBConstants.dbAutoIncrField) != 0); string strFieldNames = DBConstants.EMPTY_STRING; if (bColumnDefault) { if (fieldInfo.m_bRequired && bRequiredDefault) { strFieldNames = StringUtils.JoinNonEmpty(" ", strFieldNames, DbTypeDefault(fieldInfo.m_nType)); } } if (bAutoIncremField == false) { if (fieldInfo.m_bRequired) { strFieldNames = StringUtils.JoinNonEmpty(" ", strFieldNames, "NOT NULL"); } else { strFieldNames = StringUtils.JoinNonEmpty(" ", strFieldNames, "NULL"); } } return(strFieldNames); }
protected string DbIdentity(TableFieldDefInfo fieldInfo) { bool identityColumn = DBPlatform.AutoIncrField(fieldInfo.m_lAttributes); string strDbIdentity = DBConstants.EMPTY_STRING; if (identityColumn) { strDbIdentity = DbIdentitySQL(); } return(strDbIdentity); }
public string ClassColumnName(TableFieldDefInfo columnInfo) { return(columnInfo.ColumnName()); }
protected override string DbConvertDataType(TableFieldDefInfo fieldInfo) { string strFieldType = DBPlatform.MsSQLConvertDataType(fieldInfo.m_nType, fieldInfo.m_lSize); return(strFieldType); }
protected abstract string DbConvertDataType(TableFieldDefInfo fieldInfo);