COM C＃数据层应用程序？ [英] COM C# data layer application?

问题描述

我正在使用DAO连接到MS Access的四个旧VB6应用程序正在尝试逐步替换。我们在一个非常大的配置表中有很多关于锁/死锁的问题，这些配置表有100列，只有一行。很糟糕的设计令人头疼。



我们决定从该表中删除编辑最多的列，并根据列的功能创建两个新表，它们具有名称/值对

我们还想尝试单独的C＃数据层COM应用程序或dll来实际处理对表的访问并最终处理更多数据。所有四个VB6应用程序都需要与旧表和新表进行通信。



我们还想访问表，特别是大配置表，只需要除非检测到变化，否则可能在可能的情况下，我们会将值保存在内存中，即使用数据表等。



我的问题是....我应该使用COM事件来触发事物告诉4个程序数据库列值是否已更改？如何保持同步状态？我应该直接从数据库中直接读取吗？我们希望最小化对Access文件的运行选择并协调编辑/更新。我应该采取什么行动？

任何帮助表示赞赏。

I am working with four old VB6 applications connected to MS Access using DAO which we are trying to gradually replace. We have a lot of issues with locks/deadlocks in one very large configuration table with like 100 columns and just one row. Lots of headaches with that poor design.

We decided to remove the most edited columns from that table and create two new tables based on the columns's functionality, with them having Name/Value pairs
We also wanted to try a separate C# data layer COM application or dll to actually handle access to the tables and eventually more data. All four VB6 applications will need to talk to the old table and the new tables.

We also wanted to access the tables, particularly the large config one, as little as possible unless a change was detected. We would keep the values in memory ie with a data table, etc, when possible.

My question is....should I use COM events to trigger things to tell the 4 programs a database column value has changed? How do I keep things in 'synch'? Should I should just read from the database directly at all times? We want to minimize running selects against the Access files and coordinate edits/updates. What course of action should I use?
Any help appreciated.

推荐答案

这篇关于COM C＃数据层应用程序？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！