using NHibernate;
using NHibernate.Cfg;

Configuration = new Configuration().DataBaseIntegration(db =>
{
    db.Dialect<SpannerDialect>();
    db.ConnectionString =
        "Data Source=projects/MY-PROJECT/instances/MY-INSTANCE/databases/MY-DATABASE";
});
var sessionFactory = Configuration.BuildSessionFactory();
using var session = configuration.SessionFactory.OpenSession();

var transaction = session.BeginTransaction();
var singer = new Singer
{
    FirstName = "Jamie",
    LastName = "Allison"
};
await session.SaveAsync(singer);
await transaction.CommitAsync();

using var session = configuration.SessionFactory.OpenSession();

var singersBornBefore2000 = await session
    .Query<Singer>()
    .Where(s => s.BirthDate < new SpannerDate(2000, 1, 1))
    .OrderBy(s => s.BirthDate)
    .ToListAsync();
Console.WriteLine("Singers born before 2000:");
foreach (var singer in singersBornBefore2000)
{
    Console.WriteLine($"\t{singer.FullName}, born at {singer.BirthDate}");
}

var singersStartingWithAl = await session
    .Query<Singer>()
    .Where(s => s.FullName.StartsWith("Al"))
    .OrderBy(s => s.LastName)
    .ToListAsync();
Console.WriteLine("Singers with a name starting with 'Al':");
foreach (var singer in singersStartingWithAl)
{
    Console.WriteLine($"\t{singer.FullName}");
}

using var session = configuration.SessionFactory.OpenSession();
using var transaction = session.BeginTransaction();

// Create a Singer, Album and Track.
// Album references Singer with a normal foreign key relationship.
var singer = new Singer
{
    FirstName = "Farhan",
    LastName = "Edwards",
};
var album = new Album
{
    Title = "Thinking Jam",
    Singer = singer,
};
// Track is interleaved in Album. This means that Track must use a composite primary
// key. In this example, the primary key is the Album ID and a Track number.
var track = new Track
{
    // A TrackIdentifier consists of the parent Album and a track number.
    TrackIdentifier = new TrackIdentifier(album, 1L),
    Title = "Always Sweet",
};
await session.SaveAsync(singer);
await session.SaveAsync(album);
await session.SaveAsync(track);
await transaction.CommitAsync();

var sessionFactory = configuration.Configuration.BuildSessionFactory();

// Create a session that will always use mutations.
using var session = sessionFactory
                        .OpenSession()
                        .SetBatchMutationUsage(MutationUsage.Always);

// Create a new Singer and save it. The insert will use a Mutation.
var transaction = sessionUsingMutations.BeginTransaction();
var singer = new Singer
{
    FirstName = "Wanda",
    LastName = "Yates",
};
await session.SaveAsync(singer);
await transaction.CommitAsync();

// You can also instruct a single transaction to use mutations.
using var session2 = sessionFactory.OpenSession();
var transaction2 = session.BeginTransaction(MutationUsage.Always);