Search code examples
c#.netsql-serverbiometrics

Saving Biometric data to SQL Server

I have an upcoming project which requires the recording of thumbprint / fingerprint scans in a database (currently proposed as SQL Server). Now I have a few questions I need to explore:

  • How does SQL Server handle the embedding of images? Is it better to embed the scanned images in the database or to embed the path and store the images in a folder? My concern is the number of files could eventually reach 7 million and the data would need to be queried.
  • What software or otherwise would I need to be able to "read" a thumbprint / fingerprint image and compare it to all records in the database for duplication?
Solution

  • Look up Entity Framework as an easy-to-learn framework in C# that lets you work with databases nearly seamlessly.

    EDIT Ok, with the update to the question, it is easier to answer. For the first part. I would store the images on disk, and save the path to the image in the database. This is considered a good approach.

    For the part of software used to read fingerprints, you should search a little around for examples. There are tons of examples, but they all vary with the type of fingerprint reader that you aim to use.