public DBResult InsertLidarConfig(LidarConfig config)
{
ISqlizable sql = DB.Format(@"
INSERT INTO
sitewerx.lidar_configs (CONFIG_NAM, CONFIG_DATA)
VALUES
('{0}','{1}');
" , config.Name, config.Data);
return(DB.Insert(sql));
}
public DBResult SetSessionModeNoAutoValueOnZero()
{
QueryString sql2 = m_DB.Format("SET SESSION sql_mode='NO_AUTO_VALUE_ON_ZERO';");
DatabaseDataReader reader;
DBResult result = m_DB.Query(sql2, out reader);
using (reader)
{
// Intentionally empty
}
return(result);
}