久久久久久久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ǔ)的處理方法,對大家解決問題具有一定的參考價(jià)值,需要的朋友們下面隨著小編來一起學(xué)習(xí)吧!

                  問題描述

                  限時(shí)送ChatGPT賬號..

                  我有一個(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)制大對象 (BLOB) 數(shù)據(jù)存儲(chǔ)為文件系統(tǒng)上的文件.Transact-SQL 語句可以插入、更新、查詢、搜索和備份 FILESTREAM 數(shù)據(jù).Win32 文件系統(tǒng)接口提供對數(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ù)可能對數(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.

                  請注意,您至少需要 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ǔ)的文章就介紹到這了,希望我們推薦的答案對大家有所幫助,也希望大家多多支持html5模板網(wǎng)!

                  【網(wǎng)站聲明】本站部分內(nèi)容來源于互聯(lián)網(wǎng),旨在幫助大家更快的解決問題,如果有圖片或者內(nèi)容侵犯了您的權(quán)益,請聯(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)建對 SQL Server 實(shí)例的登錄?)
                  How to know the version and edition of SQL Server through registry search(如何通過注冊表搜索知道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久久精品免费看国产四区 | 成人免费日韩 | 亚洲一区亚洲二区 | 欧美日韩综合一区 | 伊人春色在线观看 | 欧美激情亚洲天堂 | 久久国 | 欧美一区中文字幕 | 欧美日韩在线成人 | 久草青青草 | 国产精品免费在线 | 免费亚洲成人 | 天天干b | 亚洲一区二区三区在线播放 | 日韩欧美在线一区 | 成人av播放 | 羞羞涩涩在线观看 | 欧美精三区欧美精三区 | 日本二区在线观看 | 国产女人精品视频 | 在线色网 | 亚洲一区二区av | 一级特黄网站 | 国产精品一区二区福利视频 | 99精品国自产在线 | 日韩午夜精品 | 亚洲视频精品 | 一级午夜aaa免费看三区 | 日韩成人免费av | 成年人视频免费在线观看 | 国产成人免费视频网站视频社区 | 一区二区久久 | 黄色一级视频 | www国产精品 | 男女黄网站 | 欧美性一级 | 精品视频一区二区三区 | 伊人春色在线观看 | 激情免费视频 | 99久久免费精品视频 |