Table bloat in Linq-SQL

var db = new MyDb(connString);

causes creation of all objects corresponding to all tables in database.

Database contains 500 tables.
Application accesses only few tables at a time.

Creating large number of objects which are not used is bad design.

How to force Linq-SQL to create table objects only when they are first
accessed ?

Andrus.


.

Relevant Pages

  • Re: Table bloat in Linq-SQL
    ... Andrus wrote: ... causes creation of all objects corresponding to all tables in database. ... Database contains 500 tables. ... Application accesses only few tables at a time. ...
    (microsoft.public.dotnet.languages.csharp)
  • Problem creating new portal i SPS 2003
    ... 10:55:12 Starting portal creation for 'test only'. ... 10:55:12 Service database server is 'MyServer'. ... 10:55:12 Opening virtual server. ... 10:56:58 cmd.CommandText set as: Update dbo.propertylist set DisplayName = ...
    (microsoft.public.sharepoint.portalserver)
  • RE: Another Failed To create portal error - Log
    ... 14:28:00 Starting portal creation for 'vcxvdfvfd'. ... 14:28:00 Service database server is 'ABZWS1801'. ... 14:28:40 STS alert creation redirection to SPS Alert creation. ...
    (microsoft.public.sharepoint.portalserver)
  • Re: problems with mysql_fetch_array($IsResult,MYSQL_NUM)
    ... I am trying to write a simple database class to encapsulate all the ... executes the loop. ... $IsResult is reeves no value. ... var $mResult; ...
    (comp.lang.php)
  • Re: Help with two page form
    ... database entry for this order with the Pickup Location, ... <HEAD> ... function load1() { ... var load1 = window.open('http://www.webdesignsbyjc.com/DBSample/ ...
    (comp.lang.php)
Loading