[C#][Question] About References

Hi,

So, I was searching the best way to work with some nugets like database files and there’s one thing I cannot understand. When we create a project and set some nuget (ex: SQLite) the reference is in the project, so it will stay there when build. But is the diretory of the file that is on the project or the data itself?
I ask that because I don’t know if I have to get the file of the nuget and add manually on the resource folder or if it’s included when I build the project.