Linq with INFORMATION_SCHEMA?

  • Thread starter Thread starter Mark Olbert
  • Start date Start date
M

Mark Olbert

Does anyone have references for using linq with INFORMATION_SCHEMA? In other words, setting up a DataContext so that one can use
linq to query against the INFORMATION_SCHEMA information?

- Mark
 
Hello Mark,

It seems you need some guideline for using linq with INFORMATION_SCHEMA.
Thereby, you can set up a DataContext to query against the Schema
information, correct? If I misunderstood anything here, please don't
hesitate to correct me.

I haven't any reference with LINQ and INFORMATION_SCHEMA. I think your main
issue maybe that INFORMATION_SCHEMA is a system view. VS IDE cannot
retrieve it when you are designing LINQ TO SQL item. If this is the case,
my suggestion is that you can create some Custom View to retrieve the data
from INFORMATION_SCHEMA.
For example
create view myview as select * from INFORMATION_SCHEMA.tables

Then you can drag-and-drop "myview" view from "Server Explorer" into "Linq
to SQL design interface".

Hope this helps. If you have any more concern, please feel free to update
here again. We are glad to assist you.

Have a great day,
Best regards,

Wen Yuan
Microsoft Online Community Support
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 
Back
Top