public static DatabaseType GetType(FieldTypes type) { DatabaseType databastType = null; switch (type) { case FieldTypes.BLOB: databastType = new DatabaseType(SqlDbType.VarBinary, DbType.Binary); break; case FieldTypes.DATETIME: databastType = new DatabaseType(SqlDbType.DateTime, DbType.DateTime); break; case FieldTypes.INT: databastType = new DatabaseType(SqlDbType.Int, DbType.Int32); break; case FieldTypes.TEXT: databastType = new DatabaseType(SqlDbType.VarChar, DbType.String); break; } return databastType; }
public void AddParam(String paramName, Object paramValue,DatabaseType type) { String name = MakeParam(paramName); query.Append(name); parameters.Add(new DatabaseParameter(name, paramValue,type)); }
public DatabaseParameter(String paramName, Object paramValue, DatabaseType type) { this.paramName = paramName; this.paramValue = paramValue; this.paramType = type; }