Hi All,

I need to retrieve data from sql view and update the table with last run.

Please suggest me how can do it with Wcf-sql adapter.

Thanks in advance,

Hi,

Retrieving data from SQL View is on the same line as we do it for Table, views are nothing but virtual table.

Have a look at following, the steps required to retrieve data:

1. From Table

2. From View

Thanks Maheshkumar,

But I also need to update a table with last run after getting the data each time.

How should I proceed.

Thanks,

Krishna.

Hi,

You can do that in PollingStatemet. First, fetch data followed by Update.

Can I ask you to go through the following post (Specifically step 6) : http://tech-findings.blogspot.in/2013/08/polling-data-from-sql-using-wcf-sql.html

Use a Stored Procedure.

You can very easily return one or more Result Sets then update as many other values as you need.

Basically:

select * from MyView where [your criteria]

update MyLogTable set LastQueryTime = GETDATE()