class Program
{
    const string KeyFile = "*********";
    const string ViewId = "********";

    static void Main(string[] args)
    {
        ReadOperation();
    }
    static void ReadOperation()
    {
        string gaConnection = string.Format("Key File={0};View Id={1}", KeyFile, ViewId);

        using (var con = new C1GoogleAnalyticsConnection(gaConnection))
        {
            con.Open();

            DataTable databaseTables = con.GetSchema("Tables");
            Console.WriteLine("List of Tables in database: \n");
            foreach (DataRow row in databaseTables.Rows)
            {
                //Display table names
                string tableName = row["TableName"].ToString();
                Console.WriteLine(tableName);//Table Name

                //Get column names in a table
                DataTable dtColumnsSchema = con.GetSchema("Columns", new string[] { tableName });

                //Remove column DbType
                dtColumnsSchema.Columns.Remove("DataType");

                //Add column References
                var fkCol = dtColumnsSchema.Columns.Add();
                fkCol.ColumnName = "References";

                //Populate data for column References
                DataTable dtForignKeys = con.GetSchema("foreignkeys", new string[] { tableName });

                foreach (DataRow fkRow in dtForignKeys.Rows)
                {
                    //Name of the column that is a foreign key
                    var fkColName = fkRow["ColumnName"];

                    //Find corresponding data row in dtColumnsSchema
                    var dtRow = dtColumnsSchema.Rows.Cast<DataRow>().Where(r => r["ColumnName"].ToString().Equals(fkColName)).Select(r => r).First();

                    //Fill value
                    dtRow["References"] = $"{fkRow["ForeignKeyTableName"]}.{fkRow["ForeignKeyColumnName"]}";
                }
                //Add the path to the folder where the table files will be saved
                dtColumnsSchema.ToCSV($@"E:\temp\GoogleAnalytics\{tableName}.csv"); 
            }
        }
    }
}

static class CsvHelper
{
    public static void ToCSV(this DataTable dtDataTable, string strFilePath)
    {
        using (StreamWriter sw = new StreamWriter(strFilePath, false))
        {
            //headers   
            for (int i = 0; i < dtDataTable.Columns.Count; i++)
            {
                sw.Write(dtDataTable.Columns[i]);
                if (i < dtDataTable.Columns.Count - 1)
                {
                    sw.Write(",");
                }
            }
            sw.Write(sw.NewLine);

            foreach (DataRow dr in dtDataTable.Rows)
            {
                for (int i = 0; i < dtDataTable.Columns.Count; i++)
                {
                    if (!Convert.IsDBNull(dr[i]))
                    {
                        string value = dr[i].ToString();
                        if (value.Contains(','))
                        {
                            value = String.Format("\"{0}\"", value);
                            sw.Write(value);
                        }
                        else
                        {
                            sw.Write(dr[i].ToString());
                        }
                    }
                    if (i < dtDataTable.Columns.Count - 1)
                    {
                        sw.Write(",");
                    }
                }
                sw.Write(sw.NewLine);
            }
            sw.Close();
        }
    }
}