Entity Data Browser

A User Control that lets you browse, view and edit the data in a database via the mapped LLBLGen Pro entities.
It consists of 2 panels: a schema tree view similar to LINQPad, and a GridDataEditor showing the entities of the selected type.

image 
Fig 1. Using the Entity Browser to view all the AddressType entities in an AdventureWorks DB.

Usage

It is used in the LLBLGen Entity Browser.
It is one of the LINQPad Custom Visualizers  bundled with the LLBLGen Pro Driver for LINQPad and and is launched from LINQPad with this command:

this.BrowseData()

Examples of other uses are in the Northwind.Win Exe and in the AW.Win Exe

The full class name for the the User Control is: AW.Winforms.Helpers.LLBL.UsrCntrlEntityBrowser.

Options

Schema Options

  • UseSchema - Use Table Schema to group the Entities
  • PrefixDelimiter - Table Prefix Delimiter to group Entities by (e.g. with a delimiter of _ table Sales_Order would grouped into a node called Sales)

Grid Options

  • EnsureFilteringEnabled - Specifies whether filtering is enabled in the grid, even if the underlying collection doesn't support it.
  • PageSize – The number of rows per page in the grid. Zero to turn paging off.
  • CascadeDeletes - Deletes cascade non-recursively to children of the selected entity.

Entity Lifetime Options

  • CacheDurationInSeconds - Specifies the duration that the query's result set should be cached for. Zero to turn caching off.
  • UseContext – Specifies whether a Context/Data Scope is used for entity fetches, if true then entities will remain dirty until saved or reverted, i.e. the entity stays in memory and will be reused even if re-fetched.

ADO.NET

  • CommandTimeOut - The timeout value (in seconds) to use with the ADO.NET data fetching

Todo

  • Currently it only works for LLBLGen Pro, maybe one day make an Entity Framework version
  • Add a HierarchyEditor
  • Add a refresh to reload the grid

Last edited Jul 16, 2016 at 11:21 AM by JezzaT, version 20

Comments

No comments yet.