// LINQ query to get all the column names for every Table
var model = new AttributeMappingSource().GetModel(typeof(ReportDBMLClassesDataContext));
int i = 0;
ArrayList lblList = new ArrayList();
foreach (var mt in model.GetTables())
{
i++;
Label lbl = new Label();
lbl.Text = mt.TableName.ToString();
lbl.ID = “lbl” + i;
Panel1.Controls.Add(lbl);
Panel1.Controls.Add(new LiteralControl(“<br>”));
int r = 0;
foreach (var dm in mt.RowType.DataMembers)
{
r++;
Label rlbl = new Label();
rlbl.Text = dm.MappedName.ToString();
rlbl.ID = “rlbl” + i + “” + r;
Panel1.Controls.Add(rlbl);
Panel1.Controls.Add(new LiteralControl(“<br>”));
}
}
DBML
...now browsing by tag
.NET
ADO.NET
apple
Beta
Column Names
CRUD
Data
DBML
desktop
Dynamic Data Entities Web Application
Entity Data Model
FileStreaming
Filtered Indexing
GridView
imac
intellisense
Javascript
jQuery
L2S
lecture
LINQ
mac
Merge Statements
missing search
Model
New Features
Not Dead
ntext
nvarchar(max)
Photography
Row Names
Row Number
Silver Springs
Sparse columns
SQL
Sql Server 2005
SQL Server 2008
Sql Tricks
Table Names
underwater
Visual Studio
VM Ware Fusion
VS2008
Windows 7
Windows 7 Beta
