How to convert DbDataRecord to DataTable

[Michfan]

Work on vs2010 EF. For my project need to run ESQL.I know how to run esql on EF,I use the bellow syntax to execute esql, but Face problem on convertion process want to convert DbDataRecord to DataTable.\[code\]string esql = "select c.Name, c.Email from Customers as c";ObjectQuery<DbDataRecord> customersQueryResult = new ObjectQuery<DbDataRecord>( esql, context);\[/code\]My query may be more complex may be need to join with many tables after get the customersQueryResult result Want to bind this with Asp.net control like:DDL,gridview etc.Directly I can not bind customersQueryResult with controls.Is it better idea to convert DbDataRecord to DataTable then bind the table with control?if yes then help me on conversion process .If is not then give me some syntax to bind result with controls.Need help me to convert DbDataRecord to DataTableIf have any query please ask,thanks in advanced