Capturing Uploaded Files in SQL - The Blazor File Upload Mini Course 

I’m glad they are helpful.

You are welcome.

I dislike it for most cases. It causes a significant increase in database size, backup size (and timing), and more. Besides, files don't usually have the same backup requirements as the rest of your data.

Disregard this message. After doing a bit of research I found that blob container is what i was looking for.

Glad you figured it out. Yeah, I prefer to store them away from wwwroot because if I deploy a new version of the website, I can't delete everything that currently exists. That may not seem like a big deal, but what it leads to is orphaned files that still exist but are no longer used (potential security hazard). Plus, it also limits you to only one server. If you decided to scale out (multiple web servers), you would have to replicate those images to every site copy. That's messy. Storing them in someplace like a blob container is a much more flexible solution.

If you look at the playlists on this channel, you will see all of my free courses. Here is this specific one: ru-vid.com/group/PLLWMQd6PeGY2yqBcxsKvsNHplMrGa-SeK

Thanks for the suggestion. Please add it to the list on the suggestion site so others can vote on it as well: suggestions.iamtimcorey.com/

I'm not sure what you are asking. System.Data is a namespace and couldn't be an enum.

@@IAmTimCorey Yes i Know, but i would expect to use for example Microsoft.Data.CommandType.StoredProcedure instead of System.Data.CommandType.StoredProcedure since we use now: microsoft.data.sqlclient

Don't use a global variable. Store the data in the database and then add to it with the next form. Or pass the data between components.

I'm working on a bug with the system right now. Your email should come through once it is fixed.

Yeah, it appears to be a global issue.

This is how to map for example to look for another location outside server folder (wwwroot): In Program.cs / Startup.cs (depending on .net version) add under app.UseStaticFiles() this code : app.UseStaticFiles(new StaticFileOptions { FileProvider = new PhysicalFileProvider(@"E:\images"), RequestPath = "/images" });

You do it the same way, just in a loop.

You are one a small one right now. Also, the Suggestion Site playlist is another that uses Blazor. I also have Blazor videos on this channel as well.

@@IAmTimCorey Do a live stream about htmlx and how to use it with blazor and how it will be its future. Would you replace React?

You are welcome.

The title is "Capturing Uploaded Files in SQL". That's what we are doing. We are identifying where the files are and then storing that information. I didn't say "Uploading Files to SQL" because that's not what we are doing. I know, it is a subtle difference, but it is an important one. Yes, I've seen and used the Filestream option, but I do not use it in almost any case. It is almost always a bad idea. Here is a video with more of my thoughts on the topic: ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-XnNbizvb1uM.htmlsi=Tro-t_uPG9VJ5oGR