public int Update(GpkgContents gpkgContents)
{
return(Update(new object[]
{
gpkgContents.TableName,
gpkgContents.DataType,
gpkgContents.Identifier,
gpkgContents.Description,
gpkgContents.LastChange?.ToUniversalTime(),
gpkgContents.MinX,
gpkgContents.MinY,
gpkgContents.MaxX,
gpkgContents.MaxY,
gpkgContents.SrsId
}));
}
public void Add(GpkgContents gpkgContents)
{
Add(new object[]
{
gpkgContents.TableName,
gpkgContents.DataType,
gpkgContents.Identifier,
gpkgContents.Description,
gpkgContents.LastChange?.ToUniversalTime(),
gpkgContents.MinX,
gpkgContents.MinY,
gpkgContents.MaxX,
gpkgContents.MaxY,
gpkgContents.SrsId
});
}
private static GpkgContents ReadObject(IDataRecord reader)
{
var gpkgContents = new GpkgContents();
gpkgContents.TableName = reader["table_name"].FromDbString();
gpkgContents.DataType = reader["data_type"].FromDbString();
gpkgContents.Identifier = reader["identifier"].FromDbString();
gpkgContents.Description = reader["description"].FromDbString();
gpkgContents.LastChange = reader["last_change"].ToDateTime();
gpkgContents.MinX = reader["min_x"].ToDouble();
gpkgContents.MinY = reader["min_y"].ToDouble();
gpkgContents.MaxX = reader["max_x"].ToDouble();
gpkgContents.MaxY = reader["max_y"].ToDouble();
gpkgContents.SrsId = reader["srs_id"].ToInt32();
return(gpkgContents);
}