code only mapping to make table name a variable

[Chom]

Hello,

I am creating my schema using code only and I need to create several tables using the same table schema only with a different name. I need to add a variable string for MappingConfiguration ToTable("mystring") method. In other words I need to have ToTable(MyVariable). I am not sure how to
achieve this. The problem is when I call UpdateSchema(), the variable logic is somehow lost when creating the table mapping. Below is an idea of what I am doing.

  protected override Telerik.OpenAccess.Metadata.MetadataContainer CreateModel()
{
Telerik.OpenAccess.Metadata.MetadataContainer model = base.CreateModel();
model.DefaultMapping.NullForeignKey = true;
return model;
}

protected override IList<MappingConfiguration> PrepareMapping()
{
List<MappingConfiguration> config = new List<MappingConfiguration>();

MappingConfiguration<Template> template = new MappingConfiguration<Template>();
template.MapType(x => new
{
Id = x.Id,
Name = x.Name,
Value = x.Value
}).ToTable(MyVariable);
template.HasProperty(p => p.Id).IsIdentity();
template.HasProperty(p => p.Name).IsNotNullable().IsUnicode().HasLength(100);
template.HasProperty(p => p.Value).IsNullable().IsUnicode().HasLength(100);

config.Add(template);

return config;
}
}

[Boris Georgiev]

Hello Gavin,

In order for us to understand your scenario and assist you in the best possible way, could you please provide us some more information:
1) How do you want to pass the variable to the PrepareMapping() method?
2) Do you want to use the variable only once to update the database schema?
3) Do you want to change the variable and the mapping at runtime?

I also suggest you to take a look at the Artificial Types API provided by Telerik Data Access which gives you the opportunity to your persistent model during the runtime.

I am looking forward to hearing from you.

Regards,
Boris Georgiev
Telerik

 

 

[Chom]

Hi Boris,
I was able to create the tables using script and executenonquery

​ using (DataLogFluentContext db = new DataLogFluentContext(ConnectionType))
{
db.ExecuteNonQuery("CREATE TABLE " + tables etc);
                db.SaveChanges();
}

but I would like to have the option to select between different databases to create tables. What is the best way to send a small demo app?

Thanks

Gavin

[Boris Georgiev]

Hello Gavin,

I am glad to see that you have found a solution. 

The forum thread is changed into a Product Feedback ticket, so you are now allowed to add attachments.

I am looking forward to hearing from you.

Regards,
Boris Georgiev
Telerik