Business Application in VS2010
-
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
-
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
picasso2 wrote:
I might have post this but cannot find it
It's at http://www.codeproject.com/Messages/4571906/Business-Application-Silverlight.aspx[^]. In future you can find all your messages by using the dropdown list on your name at the top right of the page.
Use the best guess