Sql – How to create a LINQ To SQL datacontext for large DB using SQLMetal when it generates a 12MB DataContext.cs file

linqlinq-to-sqlsqlmetal

My problem is this:

We have a very large Legacy DB with many SPROCs, Views & Tables.

The Designer is a "NO GO" b/c of the size.

I've configured SQL Metal to build the data context, but the resulting code file is so big (12MB) visual studio 2008 will not open it.

If SQLMetal would generate a new file for each class type (Table, View, SPROC_Result), I would be okay.

But as it works currently, I'm hosed.

Ideas??

Best Answer

You could do this:

Run SQLMetal.exe to create the .dbml file.
Create a little script or application to parse the .dbml file (which is XML) into 3 components: tables, stored procedures and views
Run SQLMetal.exe on each of the new .dbml files to create 3 separate .cs files.

In your filter phase (step 2) you could also create other arbitrary divisions of your .dbml file based on other requirements. Perhaps filter out some unnecessary tables or views. Or break the tables into logical components with separate DataContexts.

Related Solutions

C# – the syntax for an inner join in LINQ to SQL

It goes something like:

from t1 in db.Table1
join t2 in db.Table2 on t1.field equals t2.field
select new { t1.field2, t2.field3}

It would be nice to have sensible names and fields for your tables for a better example. :)

Update

I think for your query this might be more appropriate:

var dealercontacts = from contact in DealerContact
                     join dealer in Dealer on contact.DealerId equals dealer.ID
                     select contact;

Since you are looking for the contacts, not the dealers.

.net – How to do SQL Like % in Linq

.Where(oh => oh.Hierarchy.Contains("/12/"))

You can also use .StartsWith() or .EndsWith().

Best Answer

Related Solutions

C# – the syntax for an inner join in LINQ to SQL

.net – How to do SQL Like % in Linq

Related Topic