Linq2db: i need return DataTable

[MajidSafari]

hi

how can use DataTable to call store for store procedure
not like #1645

    public static IEnumerable<DataTable> spReportpAGEvISITcOUNT(this db dataConnection)
        {
            return dataConnection.QueryProc<DataTable>("spName");
        }

[sdanyliv]

It ieasy, if you need IQueryable, you do not have to use QueryProc.

return dataConnection.FromSql(“spName”);

[MajidSafari]

i don't need IQueryable

[MajidSafari]

just i need return System.Data.DataTable

because columns is dynamic

[sdanyliv]

Everything can be found in StackOverflow and analyzing linq2db extension methods:

var dataTable = new DataTable();
using (var reader = dataConnection.ExecuteReader("spName", CommandType.StoredProcedure))
{
    dataTable.Load(reader.Reader);
}

[MajidSafari]

Hi @sdanyliv

sorry for a lot question

and tanxxxxxxxxxxxxxxxx