記載著 Will 在網路世界的學習心得與技術分享 https://blog.miniasp.com/ http://www.rssboard.org/rss-specification BlogEngine.NET 3.3.7.0 zh-TW https://blog.miniasp.com/opml.axd https://blog.miniasp.com/syndication.axd Will Huang The Will Will Web 24.567110 120.970500 <p>我發現許多人對使用 LINQ 執行 JOIN 查詢並不是那麼的熟悉，而且語法也不見得像 T-SQL 那樣直覺，但事實上只是我們比較熟悉 T-SQL 的語法與資料庫架構而已，當我們換成 <a rel="nofollow" href="http://en.wikipedia.org/wiki/Object-relational_mapping" target="_blank">ORM</a> (Object-relational mapping) 技術後所有對資料的操作必須全部改以「物件」與「實體」來思考，所以在這轉換的過程經常轉不過去，連我自己也有時會忘記怎麼寫，也經常利用 <a href="/post/2008/05/05/About-Linq-Samples-and-the-Sample-Query-Explorer.aspx">Linq Samples and the Sample Query Explorer</a> 幫我查出適當的寫法。</p><p>... <a class="more" href="https://blog.miniasp.com/post/2010/10/14/LINQ-to-SQL-Query-Tips-INNER-JOIN-and-LEFT-JOIN#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2010/10/14/LINQ-to-SQL-Query-Tips-INNER-JOIN-and-LEFT-JOIN [email protected] https://blog.miniasp.com/post/2010/10/14/LINQ-to-SQL-Query-Tips-INNER-JOIN-and-LEFT-JOIN#comment https://blog.miniasp.com/post.aspx?id=173da15c-40ad-4e0e-bc9e-bce062daab74 週四, 14 十月 2010 08:09:00 +0000 LINQ SQL Server Tips linq linq to sql will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=173da15c-40ad-4e0e-bc9e-bce062daab74 https://blog.miniasp.com/trackback.axd?id=173da15c-40ad-4e0e-bc9e-bce062daab74 https://blog.miniasp.com/post/2010/10/14/LINQ-to-SQL-Query-Tips-INNER-JOIN-and-LEFT-JOIN#comment https://blog.miniasp.com/syndication.axd?post=173da15c-40ad-4e0e-bc9e-bce062daab74 <p>ASP.NET MVC 的開發原則有個 SoC (Separation of Concern) 的觀念，我們在開發較大型的 ASP.NET MVC 應用程式時會特別將資料存取層(Data Access Layer) 再細分為兩個層次，分別是 Repository Layer (資料倉儲層) 負責資料存取與欄位格式驗證，與 Service Layer (服務提供層) 負責資料篩選與商業邏輯驗證，但分層之後遇到了一個之前沒想過的問題，進而導致 LINQ to SQL 查詢效能不彰。</p><p>... <a class="more" href="https://blog.miniasp.com/post/2010/03/29/LINQ-to-SQL-Performance-Impact-on-N-Tier-Architecture#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2010/03/29/LINQ-to-SQL-Performance-Impact-on-N-Tier-Architecture [email protected] https://blog.miniasp.com/post/2010/03/29/LINQ-to-SQL-Performance-Impact-on-N-Tier-Architecture#comment https://blog.miniasp.com/post.aspx?id=2ed4733e-3656-479d-9e8b-a988b7ac40cc 週一, 29 三月 2010 06:53:25 +0000 Entity Framework LINQ ASP.NET MVC Tips linq to sql entity framework asp.net mvc will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=2ed4733e-3656-479d-9e8b-a988b7ac40cc https://blog.miniasp.com/trackback.axd?id=2ed4733e-3656-479d-9e8b-a988b7ac40cc https://blog.miniasp.com/post/2010/03/29/LINQ-to-SQL-Performance-Impact-on-N-Tier-Architecture#comment https://blog.miniasp.com/syndication.axd?post=2ed4733e-3656-479d-9e8b-a988b7ac40cc <p>在使用 <a href="http://msdn.microsoft.com/en-us/library/dd410405(VS.100).aspx" rel="nofollow" target="_blank">Model Binder</a> 繫結資料模型時 (Entity Type) ，大部分情況都是非常方便的，可有效減少 Action 參數的用量，也可大幅降低程式複雜度。但是在我們之前的某個專案就採到一個 Model Binder 的地雷，這個地雷不是 ASP.NET MVC 的 Bug，而是一個開發時應注意的地方，採用標準的寫法準沒錯。</p><p>... <a class="more" href="https://blog.miniasp.com/post/2009/11/12/ASPNET-MVC-Developer-Note-Part-12-The-Model-Binder-Traps#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2009/11/12/ASPNET-MVC-Developer-Note-Part-12-The-Model-Binder-Traps [email protected] https://blog.miniasp.com/post/2009/11/12/ASPNET-MVC-Developer-Note-Part-12-The-Model-Binder-Traps#comment https://blog.miniasp.com/post.aspx?id=76f21e4a-3403-4100-bd7e-9c846ee6018d 週四, 12 十一月 2009 08:01:55 +0000 ASP.NET MVC LINQ asp.net mvc reflection model binder linq to sql will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=76f21e4a-3403-4100-bd7e-9c846ee6018d https://blog.miniasp.com/trackback.axd?id=76f21e4a-3403-4100-bd7e-9c846ee6018d https://blog.miniasp.com/post/2009/11/12/ASPNET-MVC-Developer-Note-Part-12-The-Model-Binder-Traps#comment https://blog.miniasp.com/syndication.axd?post=76f21e4a-3403-4100-bd7e-9c846ee6018d <p>我們都知道 <a href="http://msdn.microsoft.com/zh-tw/library/system.web.caching.sqlcachedependency.aspx" rel="nofollow" target="_blank">SqlCacheDependency</a> 有個很大的限制，就是一次只能用「單一表格」做判斷，如果你有個檢視表(View)或使用的 SQL 語法有 JOIN 兩個以上的表格，就無法利用 <a href="http://msdn.microsoft.com/zh-tw/library/system.web.caching.sqlcachedependency.aspx" rel="nofollow" target="_blank">SqlCacheDependency</a> 幫你達成快取相依(CacheDependency)的設計，但我們大多的案子很少有「單一表格查詢」的狀況，以導致很多情境下無法使用 <a href="http://msdn.microsoft.com/zh-tw/library/system.web.caching.sqlcachedependency.aspx" rel="nofollow" target="_blank">SqlCacheDependency</a> 感覺十分懊惱，但我們最近想出了新方法！</p><p>... <a class="more" href="https://blog.miniasp.com/post/2009/08/25/How-to-apply-SqlCacheDependency-to-multi-table-situation#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2009/08/25/How-to-apply-SqlCacheDependency-to-multi-table-situation [email protected] https://blog.miniasp.com/post/2009/08/25/How-to-apply-SqlCacheDependency-to-multi-table-situation#comment https://blog.miniasp.com/post.aspx?id=8050b854-3325-41d9-908f-1780bfbabee5 週二, 25 八月 2009 15:14:24 +0000 LINQ .NET Framework SQL Server linq sqlcachedependency will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=8050b854-3325-41d9-908f-1780bfbabee5 https://blog.miniasp.com/trackback.axd?id=8050b854-3325-41d9-908f-1780bfbabee5 https://blog.miniasp.com/post/2009/08/25/How-to-apply-SqlCacheDependency-to-multi-table-situation#comment https://blog.miniasp.com/syndication.axd?post=8050b854-3325-41d9-908f-1780bfbabee5 <p>前陣子用了 SQL Server 2005 中極少人使用的 Query Notification 功能，且我下的 SQL 指令明明就很單純，只是做一個簡單的 SELECT 查詢卻會引來 SQL Server 的內部錯誤，自己奮戰了一個多月無解，最後還是靠微軟的技術支援中心幫我解了這個難題。</p><p>... <a class="more" href="https://blog.miniasp.com/post/2009/07/22/Internal-error-Buffer-provided-to-read-column-value-is-too-small#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2009/07/22/Internal-error-Buffer-provided-to-read-column-value-is-too-small [email protected] https://blog.miniasp.com/post/2009/07/22/Internal-error-Buffer-provided-to-read-column-value-is-too-small#comment https://blog.miniasp.com/post.aspx?id=fc4d6f80-f11d-4847-9d9d-bd20c2e7ee80 週三, 22 七月 2009 05:01:43 +0000 SQL Server LINQ .NET Framework trouble shooting sql server 2005 will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=fc4d6f80-f11d-4847-9d9d-bd20c2e7ee80 https://blog.miniasp.com/trackback.axd?id=fc4d6f80-f11d-4847-9d9d-bd20c2e7ee80 https://blog.miniasp.com/post/2009/07/22/Internal-error-Buffer-provided-to-read-column-value-is-too-small#comment https://blog.miniasp.com/syndication.axd?post=fc4d6f80-f11d-4847-9d9d-bd20c2e7ee80 <p>熟悉 LINQ to SQL 的朋友應該很清楚如何透過 Skip 與 Take 方法來取得資料的部分集合，但各位可能不知道透過這種方式分頁時有個很有可能出錯的地方，而且這個錯誤可能會讓你覺得這是 LINQ to SQL 的 Bug，有在使用 LINQ to SQL 分頁的人必看此篇文章。</p><p>... <a class="more" href="https://blog.miniasp.com/post/2009/06/03/The-important-LINQ-to-SQL-Paging-issues#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2009/06/03/The-important-LINQ-to-SQL-Paging-issues [email protected] https://blog.miniasp.com/post/2009/06/03/The-important-LINQ-to-SQL-Paging-issues#comment https://blog.miniasp.com/post.aspx?id=62276bab-c992-4537-ad53-aa9c026de2d4 週三, 3 六月 2009 16:46:01 +0000 LINQ SQL Server Tips linq linq to sql will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=62276bab-c992-4537-ad53-aa9c026de2d4 https://blog.miniasp.com/trackback.axd?id=62276bab-c992-4537-ad53-aa9c026de2d4 https://blog.miniasp.com/post/2009/06/03/The-important-LINQ-to-SQL-Paging-issues#comment https://blog.miniasp.com/syndication.axd?post=62276bab-c992-4537-ad53-aa9c026de2d4 <p>最近有個專案很奇怪，我有個 Visual Studio 方案檔，開啟後會載入好幾個專案(Project)，其中有個專案負責所有與 Data Access Layer (DAL) 有關的工作，但我每次剛開啟 Visual Studio 2008 並載入專案後都無法直接按下 F6 直接建置方案( Build Solution )，都一定要先建置(Build)含有 DBML 的那個專案，才能再按下 F6 建置整個方案。</p><p>... <a class="more" href="https://blog.miniasp.com/post/2009/05/08/Build-failed-due-to-validation-errors-in-DBML-file#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2009/05/08/Build-failed-due-to-validation-errors-in-DBML-file [email protected] https://blog.miniasp.com/post/2009/05/08/Build-failed-due-to-validation-errors-in-DBML-file#comment https://blog.miniasp.com/post.aspx?id=068e6e7f-2105-4edb-9f1e-ddfbf3eb93ef 週五, 8 五月 2009 14:38:00 +0000 LINQ Visual Basic dbml linq to sql visual studio 2008 will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=068e6e7f-2105-4edb-9f1e-ddfbf3eb93ef https://blog.miniasp.com/trackback.axd?id=068e6e7f-2105-4edb-9f1e-ddfbf3eb93ef https://blog.miniasp.com/post/2009/05/08/Build-failed-due-to-validation-errors-in-DBML-file#comment https://blog.miniasp.com/syndication.axd?post=068e6e7f-2105-4edb-9f1e-ddfbf3eb93ef <p>我們今天遇到一個特殊的例子，當資料庫中的其中一個表格設定一個 AFTER INSERT 觸發程序(Trigger)時，竟然造成新增資料失敗，錯誤訊息如下：</p><p>... <a class="more" href="https://blog.miniasp.com/post/2009/03/17/LINQ-to-SQL-Insert-may-failed-when-table-enable-Trigger#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2009/03/17/LINQ-to-SQL-Insert-may-failed-when-table-enable-Trigger [email protected] https://blog.miniasp.com/post/2009/03/17/LINQ-to-SQL-Insert-may-failed-when-table-enable-Trigger#comment https://blog.miniasp.com/post.aspx?id=856997e4-9b33-4dc8-b809-99c7cfbe192e 週二, 17 三月 2009 10:51:29 +0000 LINQ SQL Server linq to sql dbml trigger will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=856997e4-9b33-4dc8-b809-99c7cfbe192e https://blog.miniasp.com/trackback.axd?id=856997e4-9b33-4dc8-b809-99c7cfbe192e https://blog.miniasp.com/post/2009/03/17/LINQ-to-SQL-Insert-may-failed-when-table-enable-Trigger#comment https://blog.miniasp.com/syndication.axd?post=856997e4-9b33-4dc8-b809-99c7cfbe192e <p>我們常用的 <strong>LINQ to SQL</strong> 就是一種簡單、易用的 <a href="http://en.wikipedia.org/wiki/Object-relational_mapping" rel="nofollow" target="_blank">ORM</a> 技術。我們也都知道若是拿<strong>採用 ORM 技術</strong>與<strong>直接存取 Database </strong>這兩件事來比較，ORM 因為多卡了一層一定會比較慢一些些，但是採用 ORM 技術有很多機會可以調校(Tuning)，例如資料快取(Caching)、定義查詢計畫(Query Plan)等。</p><p>... <a class="more" href="https://blog.miniasp.com/post/2009/03/04/Using-ORM-must-know-Query-Plan-by-LINQ-to-SQL-example#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2009/03/04/Using-ORM-must-know-Query-Plan-by-LINQ-to-SQL-example [email protected] https://blog.miniasp.com/post/2009/03/04/Using-ORM-must-know-Query-Plan-by-LINQ-to-SQL-example#comment https://blog.miniasp.com/post.aspx?id=d004e7b3-7125-48a5-a56d-4c60a60b15a1 週三, 4 三月 2009 11:08:42 +0000 .NET Framework LINQ linq to sql orm query plan dataloadoptions will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=d004e7b3-7125-48a5-a56d-4c60a60b15a1 https://blog.miniasp.com/trackback.axd?id=d004e7b3-7125-48a5-a56d-4c60a60b15a1 https://blog.miniasp.com/post/2009/03/04/Using-ORM-must-know-Query-Plan-by-LINQ-to-SQL-example#comment https://blog.miniasp.com/syndication.axd?post=d004e7b3-7125-48a5-a56d-4c60a60b15a1 <p>我個人有習慣收集一些網路上別人整理的速查表，因為程式開發的細節真的太多了，要能全部背起來不太可能，也沒什麼意義，甚至於有人說程式設計就是一件查詢、複製、貼上的工作而已。對我來說，寫程式首重觀念與經驗，有了完整而正確的觀念，就算記不得要怎麼寫，查詢一下就馬上能寫了；而有了經驗，對於一些難解的 Bug 自然能夠迅速解開。</p><p>... <a class="more" href="https://blog.miniasp.com/post/2008/11/27/Cheat-Sheets-Collection#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2008/11/27/Cheat-Sheets-Collection [email protected] https://blog.miniasp.com/post/2008/11/27/Cheat-Sheets-Collection#comment https://blog.miniasp.com/post.aspx?id=126be478-2d17-46f3-8f17-a3e77e980aa1 週四, 27 十一月 2008 07:23:00 +0000 .NET Framework ASP.NET C# CSS JavaScript LINQ PHP Security SQL Server Subversion VBA Visual Basic Visual Studio Web .net cheat sheets asp asp.net javascript visual studio c# linq sql server css html xml rgb php security reqular expression will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=126be478-2d17-46f3-8f17-a3e77e980aa1 https://blog.miniasp.com/trackback.axd?id=126be478-2d17-46f3-8f17-a3e77e980aa1 https://blog.miniasp.com/post/2008/11/27/Cheat-Sheets-Collection#comment https://blog.miniasp.com/syndication.axd?post=126be478-2d17-46f3-8f17-a3e77e980aa1 <p>在這 Web 2.0 的時代，<a href="http://www.json.org/" rel="nofollow" target="_blank">JSON</a> 這個資料傳輸格式已經越來越多人在使用了，今年 5 月份 Json.NET 才剛<a href="https://james.newtonking.com/archive/2008/05/04/json-net-2-0-released/" rel="nofollow" target="_blank">發佈 2.0 版</a>，在前幾天(8/25)又<a href="https://james.newtonking.com/archive/2008/08/25/json-net-3-0-released/" rel="nofollow" target="_blank">發佈 3.0 版</a>，這個新版本除了修正許多所有已知的 Bugs 之外，還添加了許多新功能與特性，其中包括：</p><p>... <a class="more" href="https://blog.miniasp.com/post/2008/09/01/Json-NET-30-Released#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2008/09/01/Json-NET-30-Released [email protected] https://blog.miniasp.com/post/2008/09/01/Json-NET-30-Released#comment https://blog.miniasp.com/post.aspx?id=3f1906a4-39c7-48c0-8617-3d22a8cfee4f 週一, 1 九月 2008 03:39:47 +0000 .NET Framework ASP.NET C# JavaScript LINQ Web json asp.net .net c# javascript json.net linq will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=3f1906a4-39c7-48c0-8617-3d22a8cfee4f https://blog.miniasp.com/trackback.axd?id=3f1906a4-39c7-48c0-8617-3d22a8cfee4f https://blog.miniasp.com/post/2008/09/01/Json-NET-30-Released#comment https://blog.miniasp.com/syndication.axd?post=3f1906a4-39c7-48c0-8617-3d22a8cfee4f <p>我們通常在寫 LINQ to SQL 專案時，都會利用 Visual Studio 2008 內建的 LINQ to SQL DBML Designer 讓我們透過視覺化的介面將資料庫表格、檢視表或預儲程序從 Server Explorer 拖曳到設計視窗中，不過缺點就是當資料庫結構(DB Schema)改變了之後就需要跟著修正，我通常有以下選擇：</p><p>... <a class="more" href="https://blog.miniasp.com/post/2008/08/20/Using-SqlMetalexe-to-create-LINQ-to-SQL-DBML#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2008/08/20/Using-SqlMetalexe-to-create-LINQ-to-SQL-DBML [email protected] https://blog.miniasp.com/post/2008/08/20/Using-SqlMetalexe-to-create-LINQ-to-SQL-DBML#comment https://blog.miniasp.com/post.aspx?id=bddfe685-92f0-4e70-8552-7b835bf9447a 週三, 20 八月 2008 02:24:33 +0000 .NET Framework ASP.NET C# LINQ Visual Studio sqlmetal.exe linq to sql will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=bddfe685-92f0-4e70-8552-7b835bf9447a https://blog.miniasp.com/trackback.axd?id=bddfe685-92f0-4e70-8552-7b835bf9447a https://blog.miniasp.com/post/2008/08/20/Using-SqlMetalexe-to-create-LINQ-to-SQL-DBML#comment https://blog.miniasp.com/syndication.axd?post=bddfe685-92f0-4e70-8552-7b835bf9447a <p>之前在 Visual Studio 2008 推出的時候，同時也推出了一套 <a href="http://web.archive.org/web/20081227220317/http://www.microsoft.com/downloads/details.aspx?FamilyID=8BDAA836-0BBA-4393-94DB-6C3C4A0C98A1&amp;displaylang=en" rel="nofollow" target="_blank">Visual Studio 2008 and .NET Framework 3.5 Training Kit</a> 訓練教材，可供開發人員下載自我學習。而隨著這次 <a href="https://visualstudio.microsoft.com/vs/older-downloads/" rel="nofollow" target="_blank">Visual Studio 2008 Service Pack 1</a> 與 <a href="http://go.microsoft.com/fwlink/?LinkId=124150" rel="nofollow" target="_blank">.Net Framework 3.5 Service Pack 1</a> 的推出，也同時推出了 <a href="http://go.microsoft.com/?linkid=8719735" rel="nofollow" target="_blank">.NET 3.5 Enhancements Training Kit</a> 訓練教材，其中包含了許多新增的範例程式、簡報、實驗演練(Labs)教材等，想學習新技術的人不用在等了，趕快下載回去自修吧。</p><p>... <a class="more" href="https://blog.miniasp.com/post/2008/08/14/dot-Net-35-Enhancements-Training-Kit-RTM#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2008/08/14/dot-Net-35-Enhancements-Training-Kit-RTM [email protected] https://blog.miniasp.com/post/2008/08/14/dot-Net-35-Enhancements-Training-Kit-RTM#comment https://blog.miniasp.com/post.aspx?id=48f25352-ec9e-4b6b-b54b-0bb10ffdd54e 週四, 14 八月 2008 09:12:50 +0000 .NET Framework ASP.NET C# LINQ Visual Studio .net .net 3.5 asp.net ajax mvc will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=48f25352-ec9e-4b6b-b54b-0bb10ffdd54e https://blog.miniasp.com/trackback.axd?id=48f25352-ec9e-4b6b-b54b-0bb10ffdd54e https://blog.miniasp.com/post/2008/08/14/dot-Net-35-Enhancements-Training-Kit-RTM#comment https://blog.miniasp.com/syndication.axd?post=48f25352-ec9e-4b6b-b54b-0bb10ffdd54e <p>如果你用 LINQ to SQL 開發系統的話，若兩個關連的表格需要更新資料，但需要更新的資料是 Foreign Key 的值的話，就有些地方需要特別注意，由於透過 LINQ to SQL 讀取或寫入資料都是透過 <a href="http://en.wikipedia.org/wiki/Object-relational_mapping" rel="nofollow" target="_blank">ORM ( Object-relational mapping )</a> 的方式儲存，讓原本在資料庫中的資料改以物件的方式表達，因此對這種包含關連的物件，就不能像用 T-SQL 的方式一樣改變關連的鍵值。</p><p>... <a class="more" href="https://blog.miniasp.com/post/2008/08/06/Operation-is-not-valid-due-to-the-current-state-of-the-object#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2008/08/06/Operation-is-not-valid-due-to-the-current-state-of-the-object [email protected] https://blog.miniasp.com/post/2008/08/06/Operation-is-not-valid-due-to-the-current-state-of-the-object#comment https://blog.miniasp.com/post.aspx?id=0cb18b54-dd1f-484a-bfa2-be3ee4e76915 週三, 6 八月 2008 07:52:51 +0000 C# LINQ linq to sql linq will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=0cb18b54-dd1f-484a-bfa2-be3ee4e76915 https://blog.miniasp.com/trackback.axd?id=0cb18b54-dd1f-484a-bfa2-be3ee4e76915 https://blog.miniasp.com/post/2008/08/06/Operation-is-not-valid-due-to-the-current-state-of-the-object#comment https://blog.miniasp.com/syndication.axd?post=0cb18b54-dd1f-484a-bfa2-be3ee4e76915 <p>之前我曾經寫過一篇【<a href="/post/2008/05/24/Resolve-LINQ-to-SQL-Change-Conflict-Exception">解決 LINQ to SQL 資料庫更新衝突的情形</a>】，主要是講解在寫 LINQ to SQL 程式的時候(Code Behind)若發生衝突的解決辦法，但我最近遇到的問題是，當我的頁面用的是 DetailsView + LinqDataSource 且完全是用宣告(Declarative)的方式寫成的，也就是改頁並沒有寫任何程式碼，這時發生了衝突的狀況的錯誤訊息是 <strong>Row not found or changed</strong> （如下圖示），不過卻完全看不出哪裡錯了，只知道新增資料的時候不會出錯，但每次更新或刪除的時候都會出錯，而從堆疊追蹤(Stack Trace)所顯示的訊息來看，也沒地方讓我修改，遇到這種問題先不要驚慌，因為這應該只能用我<a href="/post/2008/05/24/Resolve-LINQ-to-SQL-Change-Conflict-Exception">文章中</a>說明的第三種方法進行設定了。</p><p>... <a class="more" href="https://blog.miniasp.com/post/2008/08/02/Update-Conflict-when-using-DetailsView-LinqDataSource-with-no-code#continue">繼續閱讀</a> ...</p> https://blog.miniasp.com/post/2008/08/02/Update-Conflict-when-using-DetailsView-LinqDataSource-with-no-code [email protected] https://blog.miniasp.com/post/2008/08/02/Update-Conflict-when-using-DetailsView-LinqDataSource-with-no-code#comment https://blog.miniasp.com/post.aspx?id=92d5e421-1fc9-4566-8007-d7dea3441f65 週六, 2 八月 2008 16:01:12 +0000 .NET Framework ASP.NET C# LINQ linq linq to sql trigger will https://blog.miniasp.com/pingback.axd https://blog.miniasp.com/post.aspx?id=92d5e421-1fc9-4566-8007-d7dea3441f65 https://blog.miniasp.com/trackback.axd?id=92d5e421-1fc9-4566-8007-d7dea3441f65 https://blog.miniasp.com/post/2008/08/02/Update-Conflict-when-using-DetailsView-LinqDataSource-with-no-code#comment https://blog.miniasp.com/syndication.axd?post=92d5e421-1fc9-4566-8007-d7dea3441f65