How to download the stl files stored in a blob storage and attach these links in a SQL Database to directly download the stl files from the storage without giving access to other files

Question

How to download the stl files stored in a blob storage and attach these links in a SQL Database to directly download the stl files from the storage without giving access to other files

Ankit Bharti 60

I want to attach the links of a stl files which are stored in a container and these links are attached in a SQL Database, so it can be given to my teammates for download a specific files mentioned in a SQL Database.

Please let me know the method to approach this concept.

Ravi Kanth Koppala 3,391 Reputation points Microsoft Employee Moderator

2023-12-19T16:47:17.9+00:00
@Ankit Bharti

To download STL files stored in Azure Blob Storage and attach the links in a SQL Database, you can follow these steps:

Use Azure Blob Storage SDKs to download the STL files from the blob storage. You can use the DownloadToStream method to download the file to a stream and then save it to a local file. Here's an example in C#:

var blobClient = new BlobClient(connectionString, containerName, blobName); var response = await blobClient.DownloadAsync(); using var streamReader = new StreamReader(response.Value.Content); using var fileStream = new FileStream(localFilePath, FileMode.Create); await streamReader.BaseStream.CopyToAsync(fileStream);

Once you have downloaded the STL files, you can insert the links to these files in the SQL Database. You can use the INSERT INTO statement to insert the links. Here's an example in T-SQL:

INSERT INTO dbo.StlFiles (FileName, FileUrl) VALUES ('example.stl', 'https://example.blob.core.windows.net/container/example.stl')

By doing this, you can give the links to your teammates for downloading specific files mentioned in the SQL Database.

References:

Tutorial: Use Azure Blob Storage with SQL Server

AI Note: This answer is generated by the Microsoft Q&A AI Assist tool.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Accepted answer

8 additional answers

Your answer

Ravi Kanth Koppala 3,391 Reputation points Microsoft Employee Moderator

2023-12-19T16:47:17.9+00:00

@Ankit Bharti

To download STL files stored in Azure Blob Storage and attach the links in a SQL Database, you can follow these steps:

Use Azure Blob Storage SDKs to download the STL files from the blob storage. You can use the DownloadToStream method to download the file to a stream and then save it to a local file. Here's an example in C#:

var blobClient = new BlobClient(connectionString, containerName, blobName); var response = await blobClient.DownloadAsync(); using var streamReader = new StreamReader(response.Value.Content); using var fileStream = new FileStream(localFilePath, FileMode.Create); await streamReader.BaseStream.CopyToAsync(fileStream);

Once you have downloaded the STL files, you can insert the links to these files in the SQL Database. You can use the INSERT INTO statement to insert the links. Here's an example in T-SQL:

INSERT INTO dbo.StlFiles (FileName, FileUrl) VALUES ('example.stl', 'https://example.blob.core.windows.net/container/example.stl')

By doing this, you can give the links to your teammates for downloading specific files mentioned in the SQL Database.

References:

Tutorial: Use Azure Blob Storage with SQL Server

AI Note: This answer is generated by the Microsoft Q&A AI Assist tool.
Deleted

This comment has been deleted due to a violation of our Code of Conduct. The comment was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Answer 1

Hello Ankit Bharti,

Thank you for posting your query here!

It appears to me that you mean to provide controlled access to specific files stored in Azure Blob Storage with SQL Database for storing access information. Please correct me if I misunderstand the issue.

To achieve this end goal, you can upload STL Files to Azure Blob Storage, then generate a SAS for each STL file in the container (at Blob level). The SAS will be a token appended to the blob URL, providing time-limited and scoped access. This allows you to control access to specific files.

In your SQL Database, create a table to store information about the STL files. This table should include columns such as FileName, SASLink. For each STL file, generate a SAS and insert the file information into the SQL Database table.

Finally, share the necessary SQL Database with your teammates. This allows them to connect to the database and retrieve SAS links for accessing specific STL files.

Please let us know if you have any further queries. I’m happy to assist you further.

Please do not forget to "Accept the answer” and “up-vote” wherever the information provided helps you, this can be beneficial to other community members.

Anand Prakash Yadav 7,860 Reputation points Microsoft External Staff

2024-01-01T04:41:18.9533333+00:00

Ankit Bharti, just checking in to see if the below answer helped. If this answers your query, do click "Accept the answer” for the same, which might be beneficial to other community members reading this thread. And, if you have any further query do let us know.

Answer 2

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Answer 3

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Answer 4

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Answer 5

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.

Comments have been turned off. Learn more

Share via

How to download the stl files stored in a blob storage and attach these links in a SQL Database to directly download the stl files from the storage without giving access to other files

8 additional answers

Your answer