当前位置：文江博客话题详情

c#如何实现线程查询Data Base

发布于 2024-10-02 13:05:17 字数 963 浏览 3 评论 0原文

你好，我有一种情况，实体是 customerManager 仓库客户和供应商我的目标是：

仓库是单例的，并在运行时打开数据库。
customerManager 将客户管理为查询仓库并更新仓库的线程（在购买员工之后）。
当仓库中的一件商品用完时，我们要求不同线程中的供应商为我们提供它，而供应商做他的事情（假设大约 5 秒），客户等待（在队列中）并在以下情况下调用供应商方法返回true（让我们假设它总是返回true）..

所以我的问题是关于三件事：

设计 - customerManager是否应该在他内部保存仓库和客户？这似乎是最好的灵魂，有人推荐吗？（c# 设计主题）
一次可以有多少个线程访问数据库？数据库可以自己处理它，这样我就不需要自己做吗？我应该为他们保存 SqlCommand(s) 吗？我应该使用数据集还是数据读取器？换句话说有人可以建议我该怎么做吗？ 我应该为 10 个线程做什么：
```
 for (int i = 0 ; i < 10 ; i++)
{
    SqlConnection sqlConnection = new SqlConnection(r_ConnectionString);      
    sqlConnection.Open();
    sqlConnection.Close();
}
```

...所以连接池将为 10 个连接打开？

**数据库ADO.NET **主题

线程应该如何在队列中等待？（以便等待供应商方法唤醒它们）如何唤醒它们？ c# 中有一个好的解决方案吗？（c# 线程主题）

我认为这个问题太长了，否则就太断章取义了，所以如果您能在标题中写下您想要引用的问题，我将不胜感激。

谢谢。

原文

hello there i have a situation the entities are customerManager warehouse customer and suppliers
my goals are :

the warehouse is singletone and open db in runtime.
the customerManager manage customers as threads who query the warehouse and update it (after buying staff).
when one of the items in the warehouse is run out of we ask supplier in a diffrent thread to supply it for us ' while the supplier does his thing (let's assume it's something like 5 seconds ) the customer waits(in queue) and invoked when the supplier method returned true (let's assume it return true always)..

so my questions are about 3 things :

design - should the customerManager holds inside him the warehouse and the customers ? it seems like the best soultion, does someone recommend otherwise?(c# design topic )
how many threads can go to the db at once ? can a db handle it by himself so i wont need to do it myself ? should I hold for them SqlCommand(s)? should I use dataset or datareader? in other words can someone advice me how to do it ?
should i do for 10 threads :
```
 for (int i = 0 ; i < 10 ; i++)
{
    SqlConnection sqlConnection = new SqlConnection(r_ConnectionString);      
    sqlConnection.Open();
    sqlConnection.Close();
}
```

...so the conection pool would be open for 10 connectiones ?

** database ADO.NET ** topic

how should the threads wait in a queue?(in order to wait to the supplier method to awake them ) how to wake them ? is there a good solution in c# for that ? (c# threads topic)

I think the question is too long but otherwise would be too out of context so I would appreciate if you would write in the the title what question you want to reference.

thank you .

分享到QQ

分享到微博

如果你对这篇内容有疑问，欢迎到本站社区发帖提问参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。

发布评论

需要登录才能够评论，你可以免费注册一个本站的账号。

涫野音 2024-10-09 13:05:17

您的工作线程可以通过 BlockingCollection 或 ConcurrentQueue。

对于连接管理，您最好这样做：

using (SqlConnection conn = new SqlConnection(...))
{
}

因为这可以确保为您调用 Dispose() 。正如其他反馈中所述，您可以执行此操作，而不必担心数据库的实际连接计数，因为 ADO.Net 在幕后管理物理连接池。

没有人可以告诉您 DataSet 或 DataReader 哪个效果最好，这取决于加载数据后您对数据的使用情况。 DataReader 依次提供每条记录的顺序读取，而 DataSet 提供底层数据库数据的内存缓存，从这个意义上来说，它是“更高级别”的抽象。

Your worker threads could be fed work via BlockingCollection or ConcurrentQueue.

For connection management you are better off doing this:

using (SqlConnection conn = new SqlConnection(...))
{
}

since this ensures Dispose() gets called for you. As noted in other feedback, you can do this without worrying about actual conn count to the DB since ADO.Net manages a pool of physical connections behind the scenes.

Nobody can tell you whether DataSet or DataReader works best, it depends on your usage of the data once it's loaded. DataReader provides a sequential read of each record in turn, while DataSet provides an in-memory cache of underlying DB data and in that sense is a 'higher-level' abstraction.

回复收藏 0 原文