public static void Test_UsersToXML(rbacLINQ2SQLDataContext db, string fname)
{
FileStream fs = new FileStream(fname + ".xml", FileMode.Append);
FileStream fs_schema = new FileStream(fname + "_schema.xml", FileMode.Append);
var user = from usr in db.User
select usr;
SqlCommand cmd = db.GetCommand(user) as SqlCommand;
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
DataSet ds = new DataSet("USER_TABLE");
adapter.Fill(ds, "User");
ds.WriteXml(fs);
ds.WriteXmlSchema(fs_schema);
var role = from r in db.Role
select r;
cmd = db.GetCommand(role) as SqlCommand;
adapter = new SqlDataAdapter(cmd);
ds = new DataSet("ROLE_TABLE");
adapter.Fill(ds, "Role");
ds.WriteXml(fs);
ds.WriteXmlSchema(fs_schema);
fs.Close();
fs_schema.Close();
return;
}
