Dynamically access table in Entity Framework Core 2.0

Question

Aryan Kumar · Answer

Yes, dynamuc access to the table is possible in Entity Framework Core 2.0. You can do this by using the DynamicSet method of the DbContext class. The DynamicSet method takes a lambda expression as a parameter. The lambda expression will be used to dynamically generate the table name.

The following code shows how to use the DynamicSet method to dynamically generate the table names:

C#

using System.Linq;
namespace EFCoreDemo
{
    public class Program
    {
        public static void Main(string[] args)
        {
            // Create a DbContext
            using var context = new MyContext();

            // Dynamically generate the table name
            var tableName = context.DynamicTableName(x => x.Id);

            // Dynamically access the table
            var entities = context.DynamicSet<Customer>(tableName);

            // Print the entities
            foreach (var entity in entities)
            {
                Console.WriteLine(entity.Name);
            }
        }
    }
    public class MyContext : DbContext
    {
        public DbSet<Customer> Customers { get; set; }
    }
    public class Customer
    {
        public int Id { get; set; }
        public string Name { get; set; }
    }
}

In this example, we first create a DbContext called MyContext. Then, we use the DynamicTableName property to dynamically generate the table name. The lambda expression takes the entity ID as a parameter and returns the table name. Finally, we dynamically access the table and output the entity.

There are few things to consider when accessing tables dynamically in Entity Framework Core 2.0:

The lambda expression must be a valid expression that returns a string.
Lambda expressions must be deterministic. This means that the same input must always produce the same output.
Lambda expression must be thread-safe. This means that the expression must be safe to be executed concurrently by multiple threads.

forum

Dynamically access table in Entity Framework Core 2.0

Can you answer this question?

1 Answers