如下图：

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

复制代码 代码如下:

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;

声明：本站（华域联盟www.cnhackhy.com）所有文章，如无特殊说明或标注，均为本站原创发布。任何个人或组织，在未征得本站同意时，禁止复制、盗用、采集、发布本站内容到任何网站、书籍等各类媒体平台。如若本站内容侵犯了原著者的合法权益，可联系我们进行处理。