public void Add(GpkgExtension gpkgExtension) { Add(new object[] { gpkgExtension.TableName, gpkgExtension.ColumnName, gpkgExtension.ExtensionName, gpkgExtension.Definition, gpkgExtension.Scope }); }
private static GpkgExtension ReadObject(IDataRecord reader) { var gpkgExtension = new GpkgExtension(); gpkgExtension.TableName = reader["table_name"].FromDbString(); gpkgExtension.ColumnName = reader["column_name"].FromDbString(); gpkgExtension.ExtensionName = reader["extension_name"].FromDbString(); gpkgExtension.Definition = reader["definition"].FromDbString(); gpkgExtension.Scope = reader["scope"].FromDbString(); return(gpkgExtension); }
public GpkgExtension Get(string tableName, string columnName, string extensionName) { GpkgExtension gpkgExtension = null; using (IDataReader reader = Db.ExecuteReader( string.Format( "SELECT table_name, column_name, extension_name, definition, scope FROM {0} WHERE {1}", GpkgExtensionsTableName, GetWhereClause(tableName, columnName, extensionName)))) { if (reader != null) { if (reader.Read()) { gpkgExtension = ReadObject(reader); } } } return(gpkgExtension); }