gistfile1.cs

    [TestFixture]
    public class FooBar : as_sql_server_integration_test
    {
        [Test]
        public void LoadingFromGoogleTest()
        {
            IEnumerable<string> metrics;
            IEnumerable<string> dimensions;

            var data = GetAnalyticsData(out metrics, out dimensions);
            var keys = metrics.Union(dimensions);
            var rows = new List<DynamicRowBuilder>();

            foreach (var entry in data.Entries)
            {
                var dynamicRow = new DynamicRowBuilder();
                entry.Metrics.Each(x => dynamicRow.AddDataColumn(x.Name, x.Value));
                entry.Dimensions.Each(x => dynamicRow.AddDataColumn(x.Name, x.Value));
                rows.Add(dynamicRow);
            }

            var table = new DynamicTableBuilder()
                .As("Google Analytics - Some Table Name")
                .WithDefinitions(keys, label => label.RemovePrefix())
                .WithRows(rows)
                .Build();
                
            WithinTransaction(session => session.SaveOrUpdate(table));

        }