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

Omer Ayna

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.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Jithu Thomas2y ago

Accepted 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 Chhaya2y ago
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.
+2