How can I cast to IEnumerable in simple.data?

Question

I have this query in simple.data

var db = Database.Open();
IEnumerable<Guid> recetas = db.Factura
    .All()
    .Where(db.Factura.ObraSocialPlan_id == obraSocialPlanId)
    .Select(db.Factura.Id)
    .Cast<Guid>();

And I'm getting

Cannot implicitly convert type 'Simple.Data.SimpleRecord' to 'System.Guid'

How should I change the query?

Sql data type is uniqueidentifier, it's a Guid and it's the primary key of the table Factura — Rodrigo Juarez, Jul 07 '12 at 13:10
I mean what type is db.Factura.Id declared as in the C# code. What is the .net type? — Preet Sangha, Jul 07 '12 at 13:13

score 8 · Accepted Answer · answered Jul 07 '12 at 13:44

You can't do this to an enumerable, but you can materialise it to a list like this:

var db = Database.Open();
IEnumerable<Guid> recetas = db.Factura
    .All()
    .Where(db.Factura.ObraSocialPlan_id == obraSocialPlanId)
    .Select(db.Factura.Id)
    .ToScalarList<Guid>();

If you want laziness, so you can pass the enumerable somewhere without having actually run the query, please raise an issue on the GitHub page: http://github.com/markrendle/Simple.Data/issues

Thanks.

How can I cast to IEnumerable in simple.data?

1 Answers1