The soundfingerprinting.sql from addictedcs

soundfingerprinting.sql's People

Contributors

Stargazers

Watchers

soundfingerprinting.sql's Issues

Missing SQL Parameter

When I try to test the app using MS SQL persistent storage I get the following error.
Procedure or function 'sp_InsertTrack' expects parameter '@TrackLengthSec', which was not supplied.

Getting System.InvalidCastException in model binder

Hi,

I'm getting System.InvalidCastException in Modelbinder.cs.

I hve ran DBScript.sql and it created 3 tables.

Can anyone please help.

Exeception redirected to
public TModel BindReader(IReader reader, Func<TModel> modelFactory) { TModel model = modelFactory(); readerAction(reader, model); return model; }

An unhandled exception of type 'System.Data.SqlClient.SqlException' occurred in System.Data.dll

Downloaded from Nuget packages

The error

Additional information: Procedure or function 'sp_InsertTrack' expects parameter '@TrackLengthSec', which was not supplied.

Here my entire code that gives the error

List<string> lstMp3Files = new List<string> {
                @"D:\15_muzikler\00 UK Top 40 Singles Charts\UK Top 40 Singles Chart 2017-01-21\Clean Bandit - Rockabye ft. Sean Paul & Anne-Marie [Official Video].mp3",
                @"D:\15_muzikler\00 UK Top 40 Singles Charts\UK Top 40 Singles Chart 2017-01-21\JP Cooper - September Song.mp3",
                @"C:\Clean Bandit - Rockabye ft. Sean Paul & Anne-Marie [Official Video].mp3"
            };

            int irLoop = 1;

            foreach (var item in lstMp3Files)
            {
                var track1 = new TrackData("track" + irLoop, "track" + irLoop, "track" + irLoop, "track" + irLoop, 2017, 215);
                // store track metadata in the datasource
                var trackReference = modelService.InsertTrack(track1);

                // create hashed fingerprints
                var hashedFingerprints = fingerprintCommandBuilder
                                            .BuildFingerprintCommand()
                                            .From(item)
                                            .UsingServices(audioService)
                                            .Hash()
                                            .Result;

                // store hashes in the database for later retrieval
                modelService.InsertHashDataForTrack(hashedFingerprints, trackReference);
                irLoop++;
            }

Recommend Projects