Business Application Silverlight
WPF
1
Posts
1
Posters
0
Views
1
Watching
-
Hello forum, (sorry if duplicate, I might have post this but cannot find it) Just created a SL Busines application. In the MYDomainService.cs the default queries are generated. public IQueryable GetDBTablesCompare() { return this.ObjectContext.DBTables; } The default returns all columns in the specified table. I would like to run a script like this: SELECT * From DBTables A FULL OUTER JOIN Information_Schema.Columns B ON A.Column_Name = B.Column_Name AND B.Table_Name = 'FY2007_DATA' AND B.Table_Schema = 'dbo' WHERE A.Table_Schema = 'dbo' AND A.Table_Name = 'FY2006_DATA' AND (A.Column_Name IS NULL OR B.Column_Name IS NULL) Any help will be greatly appreciated