class SQLCEAdapter
    {
        private string connectionString = @"Data Source=|DataDirectory|\CFDataBase.sdf";

        public void addBindChain(string trackName, string albumName = "defaultAlbum", string artistName = "defaultArtist")
        {
            using (SqlCeConnection connection = new SqlCeConnection(connectionString))
            {
                connection.Open();
                SqlCeTransaction trans = connection.BeginTransaction(IsolationLevel.ReadCommitted);
                string queryArtists = @"INSERT INTO artists (Name) Values ('" + artistName + "')";
                string queryAlbums = @"INSERT INTO albums (Name, artist) Values ('" + albumName + "', (SELECT MAX(id) FROM artists WHERE (Name = '" + artistName + "')))";
                string queryTracks = @"INSERT INTO tracks (Name, Album) Values ('" + trackName + "', (SELECT MAX(id) FROM albums WHERE Name = '" + albumName + "'))";

                SqlCeCommand commandArtists = new SqlCeCommand(queryArtists, connection, trans);
                SqlCeCommand commandAlbums = new SqlCeCommand(queryAlbums, connection, trans);
                SqlCeCommand commandTracks = new SqlCeCommand(queryTracks, connection, trans);
                try
                {
                    commandArtists.ExecuteNonQuery();
                    commandAlbums.ExecuteNonQuery();
                    commandTracks.ExecuteNonQuery();
                    trans.Commit();
                }
                catch (SqlCeException e)
                {
                    trans.Rollback();
                    Console.WriteLine(e);
                }
            }
        }
}