IsNemoEqualTrue/monitor-table-change-with-sqltabledependency

How can we use TableDependency with Entity Framework 6

Opened this issue · 3 comments

ankitshah-it commented

Hello All,

Can anybody explain how can we use Table dependency in Entity Framework 6 Application. As using DBContext or other way and share sample code of it???

Also whether Table Dependency can be used for Oracle or Other RDBMS or it can be used for only SQL Server.

Also is there any Discussion Portal So I can put query on that portal.

Thanks in Advance
Ankit Shah

tomasfabian commented

Hi Ankit Shah,
this repository is unfortunatelly not maintained anymore as Christian announced, but I will try to answer your questions instead of him.

I have an example in my repository how to use Table dependency with EF 6:
https://github.com/tomasfabian/SqlTableDependency.Extensions
, but in my opinion the interesting part is to push those changes to other clients. Actually you don't need EF at all, you can make changes directly in the database and they will be propagated to your .NET app.

Table dependency is only for MS SQL Server. It is based on Service broker. You can't use it with Oracle.

AFAIK there is no discussion portal.

Regards, Tomas Fabian

ankitshah-it commented

Hi Ankit Shah,
this repository is unfortunatelly not maintained anymore as Christian announced, but I will try to answer your questions instead of him.

I have an example in my repository how to use Table dependency with EF 6:
https://github.com/tomasfabian/SqlTableDependency.Extensions
, but in my opinion the interesting part is to push those changes to other clients. Actually you don't need EF at all, you can make changes directly in the database and they will be propagated to your .NET app.

Table dependency is only for MS SQL Server. It is based on Service broker. You can't use it with Oracle.

AFAIK there is no discussion portal.

Regards, Tomas Fabian

Hello Tomas Fabian

Thank You Very Much for valuable information.

Actually we have application developed with EF 6 so it was required. Already i have seen it can be used with any .Net Application.

But can it be possible that we have application in which both RDBMS Oracle and SQL Server using.
Now Requirement is.
If any specified changes of Oracle Database it should be detected by Application and accordingly changes should be made into SQL Server Database. And it can be reverse also..

So i am looking for such sample or Oracle Database Part as SQL Server Part is resolved here.

Thanks in Advance
Ankit Shah

tomasfabian commented

In that case you have to use change data capture in multiple databases. Kafka Connect provides sink/source connectors for both above mentioned databases.

It is not possible to achieve this with SqlTableDependency.

If you are satisfied with the answer please close the issue.

Regards Tomas