Example #1
0
        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);
        }
Example #2
0
        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);
        }
Example #5
0
 protected abstract string DbConvertDataType(TableFieldDefInfo fieldInfo);