如何使用linq读取分隔符文本文件
更新:HHH   时间:2023-1-7


这篇文章主要讲解了“如何使用linq读取分隔符文本文件”,文中的讲解内容简单清晰,易于学习与理解,下面请大家跟着小编的思路慢慢深入,一起来研究和学习“如何使用linq读取分隔符文本文件”吧!

如下图:

然后它们存储到文本文件有这样的列:

复制代码 代码如下:


First Name
Last Name
Job Title
City
Country



在我们读取这个文件之前,先建一个实体类:

复制代码 代码如下:


/// <summary>
 /// Customer entity
/// </summary>
public class Customer{
public string Firstname { get; set; }
public string Lastname { get; set; }
public string JobTitle { get; set; }
public string City { get; set; }
public string Country { get; set; }
}

接着我们使用LINQ读取整个文件:

复制代码 代码如下:


var query = from line in File.ReadAllLines(filePath)
 let customerRecord = line.Split(',')
select new Customer()
 {
Firstname = customerRecord[0],
Lastname = customerRecord[1],
 JobTitle = customerRecord[2],
City = customerRecord[3],
Country = customerRecord[4]
};
 foreach (var item in query)
{
Console.WriteLine("{0}, {1}, {2}, {3}, {4}"
 , item.Firstname, item.Lastname, item.JobTitle, item.City, item.Country);
}

要读取可以带条件的记录也可以,我们filter出Country是UK:

复制代码 代码如下:


 var query = from c in
(from line in File.ReadAllLines(filePath)
 let customerRecord = line.Split(',')
select new Customer()
{
Firstname = customerRecord[0],
Lastname = customerRecord[1],
 JobTitle = customerRecord[2],
City = customerRecord[3],
Country = customerRecord[4]
})
 where c.Country == "UK"
select c;



另一例子:

复制代码 代码如下:


var query = from c in
(from line in File.ReadAllLines(filePath)
let customerRecord = line.Split(',')
select new Customer()
{
Firstname = customerRecord[0],
Lastname = customerRecord[1],
JobTitle = customerRecord[2],
City = customerRecord[3],
Country = customerRecord[4]
})
where c.JobTitle.Contains("Sales")
select c;

感谢各位的阅读,以上就是“如何使用linq读取分隔符文本文件”的内容了,经过本文的学习后,相信大家对如何使用linq读取分隔符文本文件这一问题有了更深刻的体会,具体使用情况还需要大家实践验证。这里是天达云,小编将为大家推送更多相关知识点的文章,欢迎关注!

返回开发技术教程...