2008-8-9 20:18
kasumi_kxq
急问一个关于linq to sql 删除数据的问题,望高手解答!
public class UserService
{
private static SqlConnection connection;
private static DataContext dc;
private static Table<User> table;
public static Table<User> Table
{
get
{
string connectionString = ConfigurationManager.ConnectionStrings["MyTable"].ConnectionString;
if (connection == null)
{
connection = new SqlConnection(connectionString);
connection.Open();
}
else if (connection.State == System.Data.ConnectionState.Closed)
{
connection.Open();
}
else if (connection.State == System.Data.ConnectionState.Broken)
{
connection.Close();
connection.Open();
}
dc = new DataContext(connection);
table = dc.GetTable<User>();
return table;
}
}
public void DeleteDemo(User user) [color=Blue]//删除方法[/color]
{
var q = from p in Table
where p.LoginId == user.LoginId
select p;
foreach (User item in q)
{
Table.Attach(item);
Table.DeleteOnSubmit(item);[color=Red]//执行到这步时报错,提示:无法删除尚未附加的实体。[/color]
dc.SubmitChanges();
}
}
}
[b]更新、插入、查询都没有问题!就是删除是报上面的异常!麻烦哪位高手能够告知解决方法!!![/b]