我正在努力将我的应用程序从单个用户转换为 多用户。目前的架构是MSDE数据后端 （很快转换到SQLExpress，但尚未完成）。每个用户直接连接数据库 - 连接字符串加密存储在本地 文件中，所有设置等都存储在数据库中。问题是它似乎很快就会出现可扩展性和安全性问题。另一个问题是有一些文件，如图像文件， 存储在本地文件系统中，存储在数据库中的是文件的 路径。例如，如果UserA将图像添加到记录中，那么 UserB打开该记录，他们将无法看到图像，因为文件实际上是 在UserA的机器上。任何方向都可以通过这个方式获得赞赏。
解决方案" Matt Fielder" < mf **************** @ nospam.nospamwrote在 新闻：O0 ************** @ TK2MSFTNGP04.phx.gbl： 任何方向都可以使用 。
查看n层架构。特别是web服务和.NET 远程处理。
另一个问题是有一些文件，如图像文件， 存储在本地文件系统中，存储在数据库中的是该文件的 路径。例如，如果UserA将图像添加到记录中，那么 UserB打开该记录，他们将无法看到图像，因为文件实际上是 在UserA的机器上。任何方向都可以通过这个方式获得赞赏。
我会将图像和您拥有的任何其他二进制文件存储在数据库中 本身而不仅仅是指向其文件位置的指针。这很容易 足以将二进制文件直接写入图像字段类型并读取 它退出。
Web服务并不是一个真正的选择，因为我不想在服务器上要求IIS 。我已经开始关注远程处理 - 似乎可能是 的方式。 我知道告诉我关于远程处理的信息。 FAR太宽泛了一个问题...但是我会赞赏人们对我可以去看看我的 拥有的任何建议。其他人发现的任何书籍，网站或其他资源 特别有用吗？ （这是一个广泛的主题，并且一些资源用于不同的 科目比其他科目更好） 垃圾邮件捕手 < sp ********** @ rogerswrote in message news：Xn ******************** **************@127.0.0。 1 ... " Matt Fielder" < mf **************** @ nospam.nospamwrote在 新闻：O0 ************** @ TK2MSFTNGP04.phx.gbl： >任何方向都可以通过这个方式获得赞赏。
查看n层架构。特别是web serviecs和.NET 远程处理。
I''m working on converting my application from a single user, to a multi-user. The current architecture is with an MSDE data back end (switching to SQLExpress soon, but not quite yet). Each user connects to the database directly - the connection string is stored encrypted in a local file, and all settings etc. are stored in the database. The problem is it seems that this could rapidly run into problems with scalability and security. The other issue is there are some files such as image files that are stored in the local file system and what is stored in the database is a path to the file. For example, if UserA add an image to a record, then UserB opens that record, they won''t be able to see the image as the file is actually on UserA''s machine. Any direction in where to go with this would be appreciated.
解决方案 "Matt Fielder" <mf****************@nospam.nospamwrote in news:O0**************@TK2MSFTNGP04.phx.gbl: Any direction in where to go with this would be appreciated.Look into n-tier architecture. In particular web serviecs and .NET remoting.
The other issue is there are some files such as image files that are stored in the local file system and what is stored in the database is a path to the file. For example, if UserA add an image to a record, then UserB opens that record, they won''t be able to see the image as the file is actually on UserA''s machine. Any direction in where to go with this would be appreciated.I''d store the images and any other binaries you have in the database itself rather than just a pointer to its file location. It''s easy enough to write the binary straight into an image field type and read it back out.
Web services isn''t really an option as I don''t want to have to require IIS on servers. I''ve started looking at remoting - seems like that might be the way to go. I know that "tell me about remoting" is FAR too broad of a question... but I would appreciate any suggestions people have for where I can go look on my own. Any books, websites or other resources that others have found particularly useful? (it''s a broad topic, and some resources for different subjects are alwasy better than others) "Spam Catcher" <sp**********@rogerswrote in message news:Xn**********************************@127.0.0. 1... "Matt Fielder" <mf****************@nospam.nospamwrote in news:O0**************@TK2MSFTNGP04.phx.gbl: >Any direction in where to go with this wouldbe appreciated.Look into n-tier architecture. In particular web serviecs and .NET remoting.
更多推荐
多用户数据应用程序架构
发布评论