/// <summary> /// Build the SQLite declaration statement for a table column. /// </summary> /// <param name="dc">Data column.</param> /// <returns>Declaration of the column.</returns> private static string buildColumnDeclarationAccessColumn(IAccessColumn col) { //Column name; string sql = string.Format("{0} ", col.ColumnName); //Determine the appropriate data type; Type dataType = col.Type; //Save the type; if (dataType == typeof(float) || dataType == typeof(double)) { sql += "real"; } else if (dataType == typeof(int)) { sql += "int"; } else { sql += "text"; } //Default value; object defaultValue = col.DefaultValue; if (defaultValue != null) { sql += " default "; string sz = string.Empty; if (dataType != typeof(float) || dataType != typeof(double) || dataType != typeof(int)) { sz = "'"; } sql += string.Format("{0}{1}{0}", sz, defaultValue); } //Return the declaration; return(sql); }
/// <summary> /// Build the SQLite declaration statement for a table column. /// </summary> /// <param name="dc">Data column.</param> /// <returns>Declaration of the column.</returns> private static string buildColumnDeclarationAccessColumn(IAccessColumn col) { //Column name; string sql = string.Format("{0} ", col.ColumnName); //Determine the appropriate data type; Type dataType = col.Type; //Save the type; if (dataType == typeof(float) || dataType == typeof(double)) sql += "real"; else if (dataType == typeof(int)) sql += "int"; else sql += "text"; //Default value; object defaultValue = col.DefaultValue; if (defaultValue != null) { sql += " default "; string sz = string.Empty; if (dataType != typeof(float) || dataType != typeof(double) || dataType != typeof(int)) sz = "'"; sql += string.Format("{0}{1}{0}", sz, defaultValue); } //Return the declaration; return sql; }