public static IField Lookup(this IField source, string attributeName)
{
IRelation relation = source.Select(attributeName);
using IRelationReader reader = relation.GetReader();
if (reader.Read())
{
return(reader[0]);
}
return(null);
}
public static IEnumerable <ColumnBinding> AsBindings(this IRelation targets)
{
if (targets == null)
{
throw new ArgumentNullException(nameof(targets));
}
using IRelationReader reader = targets.GetReader();
List <ColumnBinding> bindings = new List <ColumnBinding>();
while (reader.Read())
{
bindings.AddRange(reader.AsBindings());
}
return(bindings);
}
public IList <IParameter> Add(IRelation relation)
{
if (relation == null)
{
throw new ArgumentNullException(nameof(relation));
}
using IRelationReader reader = relation.GetReader();
List <IParameter> parameters = new List <IParameter>();
while (reader.Read())
{
parameters.AddRange(this.Add(reader));
}
return(parameters);
}
public static Command AsCommand(this IRelation relation, Func <IList <IParameter>, string> textBuilder)
{
ParameterStore store = new ParameterStore();
Command command = new Command()
{
Parameters = store,
};
using var reader = relation.GetReader();
while (reader.Read())
{
IList <IParameter> parameters = store.Add(reader);
command.CommandText += textBuilder(parameters) + Environment.NewLine;
}
return(command);
}