Extraction of excel file from mysql table using entitymodel / C#

See more:

WPF

MySQL

entity-framework

C#6.0

I'm trying to get specific rows between 2 date 1 and 2 from MySQL table and convert the Result table to excel file .
I tried the mysqlConnection methode it works fine , but i want to do the same thing using entity model methode .

MysqlCoonection methode :

MySqlConnection connection = new MySqlConnection("datasource=;port=;username=;password=");
connection.Open();

string sQuery = "select * from  DB.table1 WHERE date = '" + d1 + "' and date <='" + d2+ "' ";

MySqlDataAdapter cmd= new MySqlDataAdapter(sQuery, connection);
DataSet ds = new DataSet();
cmd.Fill(ds);

//Conversion part code  
            Excel.Application app;
            Excel.Workbook wb;
            Excel.Worksheet ws;

            object misValue = System.Reflection.Missing.Value;

            app = new Excel.Application();
            app.Visible = true;
            wb = app.Workbooks.Add(misValue);

            ws = (Excel.Worksheet)wb.ActiveSheet;


            for (int i = 0; i < ds.Tables[0].Columns.Count; i++)
            {
                ws.Cells[1, i + 1] = ds.Tables[0].Columns[i].ColumnName;
            }
         

            for (int k = 1; k < ds.Tables[0].Rows.Count; k++)
            {

                for (int j = 0; j < ds.Tables[0].Columns.Count; j++)
                {
                    ws.Cells[k + 1, j + 1] = ds.Tables[0].Rows[k][j].ToString();
                            
                }


            }

What I have tried:

What i have tried in Entity methode :

table_Entity result = new table_Entity();

 var  EntityQuery=from t in DB.Table1 where t.date >= d1 && t.date <=  d2  select t;
 var result = EntityQuery.ToList(); 

Is it possible to use var result and copy it in dataset to use it in the same Conversion excel code part ?


Thank you for your help and attention .