Google Merchant Center plugin

[drtikol]

Not work correctly with SQL CE. SQL CE not support OVER an ROW_NUMBER function

[mgesing]

The entity framework does not support to share context instances across repositories and therefore generic SQL is required here. See no way to accomplish that with CE supported syntax.

[drtikol]

SQL CE 4 (SQL 2012] support OFFSET {0} ROWS FETCH NEXT {1} ROWS ONLY. I am used other SQL query to get total count with where clause.

[mgesing]

I will have a look on it.

[drtikol]

Note: subquery as t3 not necessary. OFFSET work on SQL Server 2012 above.

[mgesing]

Updated... it's working but not a very nice solution. It looks like a workaround for a insufficiency of a database product.