I'm looking for an example of fetching images from multiple tables to

Question

I am looking for a code to list the expression stored in the imagepath variable in the image table from the physical image file folder according to the imageid relationship from the product id to the image table linked to it in multiple related tables.

Jithu Thomas · Answer

// Assuming you have established connection details for your database and Azure Blob Storage // Function to get image path based on product ID public string GetImagePath(int productID) { string imagePath = null; // Connect to your database using (SqlConnection connection = new SqlConnection(connectionString)) { connection.Open(); // Query to get ImageURL from Images table based on product ID string query = "SELECT ImageURL FROM Images WHERE ProductID = @productID"; using (SqlCommand command = new SqlCommand(query, connection)) { command.Parameters.AddWithValue("@productID", productID); // Execute the query and get the ImageURL using (SqlDataReader reader = command.ExecuteReader()) { if (reader.Read()) { imagePath = reader.GetString(0); // Assuming ImageURL is the first column (index 0) } } } } // Construct the complete image URL using the base URL for your Azure Blob Storage container if (imagePath != null) { string blobStorageURL = "https:// .blob.core.windows.net/ /"; imagePath = blobStorageURL + imagePath; } return imagePath; } This is a sample code. but the basic idea is same for all sources.

Jayraj Chhaya · Answer

Hi Omer Ayna, you can use Entity Framework to query the database and retrieve the image path based on the specified relationship. using (var context = new YourDbContext()) { var imagePath = context.Products .Where(p => p.ProductId == yourProductId) .SelectMany(p => p.ImageTable) .Select(i => i.ImagePath) .FirstOrDefault(); } In this code snippet: YourDbContext should be replaced with your actual Entity Framework context. yourProductId should be the specific product id you are interested in. ImageTable should be replaced with the actual navigation property representing the relationship to the image table. ImagePath is the property in the image table that stores the image path. This code fetches the image path from the image table based on the product id relationship. Adjust the query according to your specific database schema and Entity Framework setup.