All geek questions in one place

.NET EntityStoreSchemaFilterEntry Filter Templates

The first question is for SO, I hope I do it right.;)

Regarding System.Data.Entity.Design.EntityStoreSchemaFilterEntry:

I am looking for detailed documentation for this class. MSDN documents have nothing but an indication of what properties and their data types exist. I want to create a well-defined list of filters for

EntityStoreSchemaGenerator.GenerateStoreMetadata(
   IEnumerable<EntityStoreSchemaFilterEntry> filters
)

In particular:

  • Do I need to set all Exceptions before Permission so that only returned records are returned?
  • What are the consequences of using null in any of the parameters? What about an empty string? Comments about this seem contradictory and do not correspond to my experience of use.
  • Is the correct "all" pattern simple "%"?

My goal is to exclude all tables, views, and filters, and then allow only the ones I want. If I try to do this, I get an edmx file without entities. It seems my Exclude All takes precedence over all the tables I tried to include. If I do not try to exclude tables that I do not need, I get the tables that I allowed, plus all the other tables in the database, which makes filtering unnecessary.

For reference, the only information I can find about template templates for filters is here: http://msdn.microsoft.com/en-us/library/ms710171(VS.85).aspx

Please note that I went beyond the scope of EdmGen, noted errors and limitations in EdmGen2, and now I'm trying to accomplish what I need with the extended EdmGen2 database .

Thank!

, :

AEF ADO.NET Entity Framework
Tables Views Functions
EntityStoreSchemaFilterObjectTypes EntityStoreSchemaFilterEffect
EntityStoreSchemaGenerator GenerateStoreMetadata
EntityModelSchemaGenerator
SSDL CSDL MSL EDMX
EdmGen EdmGen2
+3
1

, SSDL .

List<EntityStoreSchemaFilterEntry> filters = new List<EntityStoreSchemaFilterEntry>();
// Just generate for the Document table.
filters.Add(new EntityStoreSchemaFilterEntry(null, "dbo", "TargetTableNameHere", EntityStoreSchemaFilterObjectTypes.Table, EntityStoreSchemaFilterEffect.Allow));
filters.Add(new EntityStoreSchemaFilterEntry(null, "dbo", "%", EntityStoreSchemaFilterObjectTypes.Function, EntityStoreSchemaFilterEffect.Exclude));

// generate the SSDL
string ssdlNamespace = modelName + "Model.Store";
EntityStoreSchemaGenerator essg = new EntityStoreSchemaGenerator(provider, connectionString, ssdlNamespace);
essg.GenerateForeignKeyProperties = includeForeignKeys;

IList<EdmSchemaError> ssdlErrors = essg.GenerateStoreMetadata(filters, version);

.

+1

Source: https://habr.com/ru/post/1727696/

More articles:


All Articles