private TableMapping GetMappingByQuery(string sql, string name)
{
return(database.ExecuteEnumerable(
sql, new object[] { name.ToLower() },
r => new TableMapping(r.GetString(0),
r.GetString(1),
TableMapping.ParseTableType(r.GetString(2)),
r.GetString(3)
.Split(new[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries)
.Select(PropertyMapping.Parse).ToArray()))
.SingleOrDefault());
}
private TableMapping LoadMappingOrNull(string queryName)
{
const string sql = "select queryTableName,dbName,type,properties " +
"from simple1c__tableMappings " +
"where lower(queryTableName) = lower(@p0)" +
"limit 1";
return(database.ExecuteEnumerable(
sql, new object[] { queryName.ToLower() },
r => new TableMapping(r.GetString(0),
r.GetString(1),
TableMapping.ParseTableType(r.GetString(2)),
r.GetString(3)
.Split(new[] { "\r\n" }, StringSplitOptions.RemoveEmptyEntries)
.Select(PropertyMapping.Parse).ToArray()))
.SingleOrDefault());
}
