c# – 解析为纯文本的新段落

我想转换一下：

The victory halted Spain&rsquo;s 35-game unbeaten streak,handing the Spanish their first defeat since November 2006. The Americans now advance to the final Sunday to face the winner of Thursday&rsquo;s semifinal between South Africa and Brazil,the five-time World Cup winner. Brazil defeated the Americans,3-0,in their earlier meeting in this tournament.<br>
<br>
In the final,though,the United States will be without midfielder Michael Bradley,who received a red card for a harsh tackle in the 87th minute,the third such ejection for the Americans in this tournament. It was the only careless blemish on an otherwise nearly perfect evening.

在这：

The victory halted Spain’s 35-game unbeaten streak,handing the Spanish their first defeat since November 2006. The Americans now advance to the final Sunday to face the winner of Thursday’s semifinal between South Africa and Brazil,in their earlier meeting in this tournament.

In the final,the third such ejection for the Americans in this tournament. It was the only careless blemish on an otherwise nearly perfect evening.

我使用以下代码行将更改为新行字符：

value = value.Replace("<br>",Environment.NewLine).Trim();

运行该代码后,这是我的数据库中保存的内容：

The victory halted Spain's 35-game unbeaten streak,handing the Spanish their first defeat since November 2006. The Americans now advance to the final Sunday to face the winner of Thursday's semifinal between South Africa and Brazil,in their earlier meeting in this tournament.    In the final,the third such ejection for the Americans in this tournament. It was the only careless blemish on an otherwise nearly perfect evening.

如果我将解析后的文本保存到我的数据库并将其粘贴到记事本或Word中,我只得到一个而不是两个.

这是处理这个问题的正确方法吗？我使用的数据库是SQL Server 2005.