久久久久久久av_日韩在线中文_看一级毛片视频_日本精品二区_成人深夜福利视频_武道仙尊动漫在线观看

    <i id='FSyop'><tr id='FSyop'><dt id='FSyop'><q id='FSyop'><span id='FSyop'><b id='FSyop'><form id='FSyop'><ins id='FSyop'></ins><ul id='FSyop'></ul><sub id='FSyop'></sub></form><legend id='FSyop'></legend><bdo id='FSyop'><pre id='FSyop'><center id='FSyop'></center></pre></bdo></b><th id='FSyop'></th></span></q></dt></tr></i><div class="qwawimqqmiuu" id='FSyop'><tfoot id='FSyop'></tfoot><dl id='FSyop'><fieldset id='FSyop'></fieldset></dl></div>

    <small id='FSyop'></small><noframes id='FSyop'>

    <legend id='FSyop'><style id='FSyop'><dir id='FSyop'><q id='FSyop'></q></dir></style></legend>

      • <bdo id='FSyop'></bdo><ul id='FSyop'></ul>

        <tfoot id='FSyop'></tfoot>

        WinForms 應(yīng)用程序設(shè)計(jì)——將文檔從 SQL Server 移動(dòng)

        WinForms application design - moving documents from SQL Server to file storage(WinForms 應(yīng)用程序設(shè)計(jì)——將文檔從 SQL Server 移動(dòng)到文件存儲(chǔ))

        • <i id='QOeFK'><tr id='QOeFK'><dt id='QOeFK'><q id='QOeFK'><span id='QOeFK'><b id='QOeFK'><form id='QOeFK'><ins id='QOeFK'></ins><ul id='QOeFK'></ul><sub id='QOeFK'></sub></form><legend id='QOeFK'></legend><bdo id='QOeFK'><pre id='QOeFK'><center id='QOeFK'></center></pre></bdo></b><th id='QOeFK'></th></span></q></dt></tr></i><div class="qwawimqqmiuu" id='QOeFK'><tfoot id='QOeFK'></tfoot><dl id='QOeFK'><fieldset id='QOeFK'></fieldset></dl></div>

          <small id='QOeFK'></small><noframes id='QOeFK'>

            <tbody id='QOeFK'></tbody>

            • <legend id='QOeFK'><style id='QOeFK'><dir id='QOeFK'><q id='QOeFK'></q></dir></style></legend><tfoot id='QOeFK'></tfoot>
                • <bdo id='QOeFK'></bdo><ul id='QOeFK'></ul>
                • 本文介紹了WinForms 應(yīng)用程序設(shè)計(jì)——將文檔從 SQL Server 移動(dòng)到文件存儲(chǔ)的處理方法,對(duì)大家解決問題具有一定的參考價(jià)值,需要的朋友們下面隨著小編來一起學(xué)習(xí)吧!

                  問題描述

                  限時(shí)送ChatGPT賬號(hào)..

                  我有一個(gè)連接到 SQL Server 的標(biāo)準(zhǔn) WinForms 應(yīng)用程序.該應(yīng)用程序允許用戶使用圖像列將當(dāng)前存儲(chǔ)在數(shù)據(jù)庫中的文檔上傳到表格中.

                  I have a standard WinForms application that connects to a SQL Server. The application allows users to upload documents which are currently stored in the database, in a table using an image column.

                  我需要更改此方法,以便將文檔存儲(chǔ)為文件,并將指向該文件的鏈接存儲(chǔ)在數(shù)據(jù)庫表中.

                  I need to change this approach so the documents are stored as files and a link to the file is stored in the database table.

                  使用當(dāng)前的方法 - 當(dāng)用戶上傳文檔時(shí),他們不受存儲(chǔ)方式的影響,因?yàn)樗麄冞B接到數(shù)據(jù)庫,他們不需要知道關(guān)于文件存儲(chǔ)位置的任何信息,沒有特殊的目錄權(quán)限等是必要的.如果我為文檔設(shè)置網(wǎng)絡(luò)共享,我希望避免任何 IT 問題,例如用戶必須有權(quán)訪問此目錄才能上傳或訪問現(xiàn)有文檔.

                  Using the current approach - when the user uploads a document they are shielded from how this is stored, as they have a connection to the database they do not need to know anything about where the files are stored, no special directory permissions etc are required. If I set up a network share for the documents I want to avoid any IT issues such as the users having to have access to this directory to upload to or access existing documents.

                  有哪些選項(xiàng)可以做到這一點(diǎn)?我想有一個(gè)臨時(shí)數(shù)據(jù)庫,以與當(dāng)前方法相同的方式將文檔上傳到其中,然后在服務(wù)器上運(yùn)行一個(gè)進(jìn)程以將這些文件保存到文件存儲(chǔ)中.然后可以刪除并重新創(chuàng)建該數(shù)據(jù)庫以回收任何空間.有沒有更好的方法?

                  What are the options available to do this? I thought of having a temporary database where the documents are uploaded to in the same way as the current approach and then a process running on the server to save these to the file store. This database could then be deleted and recreated to reclaim any space. Are there any better approaches?

                  附加信息:我的應(yīng)用程序沒有網(wǎng)絡(luò)服務(wù)器元素,所以我認(rèn)為 WCF 服務(wù)是不可能的

                  ADDITIONAL INFO: There is no web server element to my application so I do not think a WCF service is possible

                  推薦答案

                  您是否有理由首先將文件從數(shù)據(jù)庫中取出?

                  Is there a reason why you want to get the files out of the database in the first place?

                  如何仍然將它們保存在 SQL Server 中,但使用 FILESTREAM 列 而不是 IMAGE?

                  How about still saving them in SQL Server, but using a FILESTREAM column instead of IMAGE?

                  引自鏈接:

                  FILESTREAM 使基于 SQL Server 的應(yīng)用程序能夠存儲(chǔ)非結(jié)構(gòu)化的文件系統(tǒng)上的數(shù)據(jù),例如文檔和圖像.應(yīng)用可以利用豐富的流 API 和文件的性能同時(shí)保持系統(tǒng)之間的事務(wù)一致性非結(jié)構(gòu)化數(shù)據(jù)和相應(yīng)的結(jié)構(gòu)化數(shù)據(jù).

                  FILESTREAM enables SQL Server-based applications to store unstructured data, such as documents and images, on the file system. Applications can leverage the rich streaming APIs and performance of the file system and at the same time maintain transactional consistency between the unstructured data and corresponding structured data.

                  FILESTREAM 將 SQL Server 數(shù)據(jù)庫引擎與 NTFS 文件集成系統(tǒng)通過將 varbinary(max) 二進(jìn)制大對(duì)象 (BLOB) 數(shù)據(jù)存儲(chǔ)為文件系統(tǒng)上的文件.Transact-SQL 語句可以插入、更新、查詢、搜索和備份 FILESTREAM 數(shù)據(jù).Win32 文件系統(tǒng)接口提供對(duì)數(shù)據(jù)的流式訪問.

                  FILESTREAM integrates the SQL Server Database Engine with an NTFS file system by storing varbinary(max) binary large object (BLOB) data as files on the file system. Transact-SQL statements can insert, update, query, search, and back up FILESTREAM data. Win32 file system interfaces provide streaming access to the data.

                  FILESTREAM 使用 NT 系統(tǒng)緩存來緩存文件數(shù)據(jù).這有助于減少 FILESTREAM 數(shù)據(jù)可能對(duì)數(shù)據(jù)庫引擎產(chǎn)生的任何影響表現(xiàn).不使用 SQL Server 緩沖池;因此,這內(nèi)存可用于查詢處理.

                  FILESTREAM uses the NT system cache for caching file data. This helps reduce any effect that FILESTREAM data might have on Database Engine performance. The SQL Server buffer pool is not used; therefore, this memory is available for query processing.

                  這樣你就可以兩全其美:
                  文件將作為文件存儲(chǔ)在硬盤上(可能比將它們存儲(chǔ)在數(shù)據(jù)庫中更快),但您不必關(guān)心文件共享、權(quán)限等.

                  So you would get the best out of both worlds:
                  The files would be stored as files on the hard disk (probabl faster compared to storing them in the database), but you don't have to care about file shares, permissions etc.

                  請(qǐng)注意,您至少需要 SQL Server 2008 才能使用 FILESTREAM.

                  Note that you need at least SQL Server 2008 to use FILESTREAM.

                  這篇關(guān)于WinForms 應(yīng)用程序設(shè)計(jì)——將文檔從 SQL Server 移動(dòng)到文件存儲(chǔ)的文章就介紹到這了,希望我們推薦的答案對(duì)大家有所幫助,也希望大家多多支持html5模板網(wǎng)!

                  【網(wǎng)站聲明】本站部分內(nèi)容來源于互聯(lián)網(wǎng),旨在幫助大家更快的解決問題,如果有圖片或者內(nèi)容侵犯了您的權(quán)益,請(qǐng)聯(lián)系我們刪除處理,感謝您的支持!

                  相關(guān)文檔推薦

                  Can I figure out a list of databases and the space used by SQL Server instances without writing SQL queries?(我可以在不編寫 SQL 查詢的情況下找出數(shù)據(jù)庫列表和 SQL Server 實(shí)例使用的空間嗎?) - IT屋-程序員軟件開發(fā)
                  How to create a login to a SQL Server instance?(如何創(chuàng)建對(duì) SQL Server 實(shí)例的登錄?)
                  How to know the version and edition of SQL Server through registry search(如何通過注冊(cè)表搜索知道SQL Server的版本和版本)
                  Why do I get a quot;data type conversion errorquot; with ExecuteNonQuery()?(為什么會(huì)出現(xiàn)“數(shù)據(jù)類型轉(zhuǎn)換錯(cuò)誤?使用 ExecuteNonQuery()?)
                  How to show an image from a DataGridView to a PictureBox?(如何將 DataGridView 中的圖像顯示到 PictureBox?)
                  SQL Server 2012 Management Studio for Windows XP(適用于 Windows XP 的 SQL Server 2012 Management Studio)

                    <legend id='gu2nu'><style id='gu2nu'><dir id='gu2nu'><q id='gu2nu'></q></dir></style></legend>

                    <i id='gu2nu'><tr id='gu2nu'><dt id='gu2nu'><q id='gu2nu'><span id='gu2nu'><b id='gu2nu'><form id='gu2nu'><ins id='gu2nu'></ins><ul id='gu2nu'></ul><sub id='gu2nu'></sub></form><legend id='gu2nu'></legend><bdo id='gu2nu'><pre id='gu2nu'><center id='gu2nu'></center></pre></bdo></b><th id='gu2nu'></th></span></q></dt></tr></i><div class="qwawimqqmiuu" id='gu2nu'><tfoot id='gu2nu'></tfoot><dl id='gu2nu'><fieldset id='gu2nu'></fieldset></dl></div>

                    <small id='gu2nu'></small><noframes id='gu2nu'>

                      <tbody id='gu2nu'></tbody>
                      • <tfoot id='gu2nu'></tfoot>

                            <bdo id='gu2nu'></bdo><ul id='gu2nu'></ul>

                          • 主站蜘蛛池模板: 亚洲欧美日韩一区二区 | 青青国产 | 欧美亚洲在线观看 | 五月激情久久 | 激情综合网五月 | 国产黄色在线播放 | 中文在线视频 | 成人性色生活片 | 一区二区三区免费看 | 韩国精品一区 | 又黄又爽又刺激的视频 | 亚洲一区久久 | 亚洲国产免费 | 成年人免费视频网站 | 极品淫少妇 | 九九九视频 | 欧美一级特黄视频 | 国产成人免费 | 久久99热这里只频精品6学生 | 亚洲午夜一区 | 亚洲www啪成人一区二区麻豆 | 国产一区久久 | 亚洲影音 | 成人国产在线观看 | 日韩在线视频播放 | 日日不卡av| 日韩成人在线观看 | 三级在线看 | 免费毛片观看 | 国产精品福利视频 | 久久精品在线视频 | 免费国产一区 | 欧美日韩中文在线 | 中文字幕91 | 爱搞逼综合网 | 免费的黄色大片 | 美女久久久久 | 国产成人精品一区二区三区福利 | 狠狠干免费视频 | 免费在线成人网 | 久久精品黄色 |