Silverlight business application
-
How can I run a store procedure (SQL 2008) from domain services? default method is to simple public IQueryable GetCars() { return this.ObjectContext.Cars; } It does not have to be a SP, I just thought it may be cleaner, basically what I need to run is something like this: Select col1 from DBTables where ltrim(rtrim(col1)) not in (select ltrim(rtrim(col2)) from DBTables where col2 is not null) order by 1 Select col2 from DBTables where ltrim(rtrim(col2)) not in (select ltrim(rtrim(col1)) from DBTables where col1 is not null) order by 1 any help is greatly appreciated
-
How can I run a store procedure (SQL 2008) from domain services? default method is to simple public IQueryable GetCars() { return this.ObjectContext.Cars; } It does not have to be a SP, I just thought it may be cleaner, basically what I need to run is something like this: Select col1 from DBTables where ltrim(rtrim(col1)) not in (select ltrim(rtrim(col2)) from DBTables where col2 is not null) order by 1 Select col2 from DBTables where ltrim(rtrim(col2)) not in (select ltrim(rtrim(col1)) from DBTables where col1 is not null) order by 1 any help is greatly appreciated
This link could possible help you - Working with Entity Data Model and Executing Stored Procedures[^].
Apps - Color Analyzer | Arctic | XKCD | Sound Meter | Speed Dial