How can I cast a collection

Question

This code:

IList<string> quids;
quids = db.Database.SqlQuery<string>("dbo.getById @Id",
                new SqlParameter { ParameterName = "Id", Value = 1 });

Produces the following error message:

Cannot implicitly convert type 'System.Data.Entity.Infrastructure.DbRawSqlQuery' to 'System.Collections.Generic.IList'.

An explicit conversion exists (are you missing a cast?)

Can someone explain to me how I can cast a collection?

Answer 1

IList<string> result = oldCollection.ToList();

DbRawSqlQuery<T> Does not implement the IList<T> interface (so, no direct cast possible). But it implements IEnumerable<T>, so you can call .ToList().