ExtractData.cs

public void ExtractData()
{
    try
    {
        DataTable dtList = GetTableList();
        DataSet ds = new DataSet();
        foreach (DataRow row in dtList.Rows)
        {
            string tableName = row[0].ToString();
            DataTable dtData = FetchData(tableName);
            ds.Tables.Add(dtData);
        }
        if (ds.Tables.Count > 0)
        {
            XmlSerializer ser = new XmlSerializer(typeof(DataSet));
            string xmlFileName = "Dbdata.xml";
            string fullPath = Path.Combine(_directoryPath, xmlFileName);
            using (TextWriter writer = new StreamWriter(fullPath))
            {
                ser.Serialize(writer, ds);
                writer.Close();
            }
            PrepareZip(fullPath);
            File.Delete(fullPath);
        }
    }
    catch (Exception ex)  { throw ex; }
}