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);
}
