Advertisement
Guest User

Untitled

a guest
Jan 16th, 2017
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.20 KB | None | 0 0
  1. public void GetListOfTables()
  2. {
  3. try
  4. {
  5. using (var dbContext = new CustomerRelationshipIndexEntities())
  6. {
  7. var metadata = ((IObjectContextAdapter)dbContext).ObjectContext.MetadataWorkspace;
  8.  
  9. var tables = metadata.GetItemCollection(DataSpace.SSpace)
  10. .GetItems<EntityContainer>()
  11. .Single()
  12. .BaseEntitySets
  13. .OfType<EntitySet>()
  14. .Where(s => !s.MetadataProperties.Contains("Type")
  15. || s.MetadataProperties["Type"].ToString() == "Tables");
  16.  
  17. foreach (var table in tables)
  18. {
  19. // I need to read the column names of the current table
  20. }
  21. }
  22. }
  23. catch (Exception ex)
  24. {
  25. string errormessage = el.CreateErrorMessage(ex);
  26. el.LogFileWrite(errormessage);
  27. }
  28. }
  29.  
  30. var names = typeof(AllowedUser).GetProperties()
  31. .Select(property => property.Name)
  32. .ToArray();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement