how to generate a xml file for a table in sql server using Linq to sql help me--------

Hi,

Try this easy way.

SqlDataAdapter cmd = new SqlDataAdapter("select * from " + tab, con);

 DataSet ds = new DataSet();

 cmd.Fill(ds,tab);


ds.WriteXml("c:\\DB\\" + tab +".xml", XmlWriteMode.WriteSchema);