c# - LINQ: Query body must end with a select clause or a group clause -

when executing linq code getting error a query body must end select clause or group clause

i use linq , reason not being able figure out problem on code. see below linq code , guide me mistake getting error.

    string[] csvlines = file.readalllines(filename);     var query = csvline in csvlines     let data = csvline.split(',').skip(1)     .select(a => new user     {         csrname = data[6],         callstart = data[0],         callduration = data[1],         ringduration = int.parse(data[2]),         direction = int.parse(data[3]),         isinternal = int.parse(data[4]),         continuation = int.parse(data[5]),         parktime = int.parse(data[7])     })     .tolist(); 

i believe top row header row. mixing query , method syntax here. can write query shown below:

var query = csvlines.skip(1).select(x =>         {             var data = x.split(',');              return new user             {                 csrname = data[6],                 callstart = data[0],                 callduration = data[1],                 ringduration = int.parse(data[2]),                 direction = int.parse(data[3]),                 isinternal = int.parse(data[4]),                 continuation = int.parse(data[5]),                 parktime = int.parse(data[7])             };         });