SQL-based picture database (cataloguing files)

Question

In my project I wanted to make an sql datatable with photo IDs and internal server links to them. So far I found only one way: use file name and upload directory.
Tags though may be stored juust near those two things in table.

Question is: is this the *right* way to do? If not, is there another one? Is there a way to assign *direct* link to a file to speed up search process?

Language used: c#.

Answer 1

I couldn't understand if that was the way you found to solve it. But, why not create a directory for the photos data inside your project folder?

You can save the destination on database. (i.e. Using . or ..)
And then in C# you do select to get the destination as a varchar (string in C#) and load it when necessary.