Data Annotation

HOW TO：加入中繼資料類別
Code First Data Annotations ***
System.ComponentModel.DataAnnotations
MetadataTypeAttribute
UIHintAttribute

[C#] 取得欄位的資料標記 Data Annotation from Metadata Class
Data Annotations
More Data Annotations

[料理佳餚] 讓 FluentValidation 把參數的檢查條件口語化

Can I check modelstate without modelbinding?

---

初學ASP.NET MVC學習筆記(九)-Templates
ASP.NET MVC學習筆記(十一)-超好用的Templates
ASP.NET MVC 學習筆記(十三)-自訂DataAnnotationsModelMetadataProvider讓UIHint在MVC中可以傳遞參數

ASP.NET MVC - Entity Framework - C# - How to get DisplayAttribute properties at run-time

---

一個或多個實體的驗證失敗。如需詳細資料，請參閱 'EntityValidationErrors' 屬性。

關閉Entity的驗證 Entities.Configuration.ValidateOnSaveEnabled = true;

參考: ASP.NET MVC使用筆記 只改某筆資料欄位儲存的時候，出現了DbEntityValidationException?

---

T4 Metadata and Data Annotations Template

POCO Entity Generator (Metadata)

Dapper.Net

Dapper - a simple object mapper for .Net
Dapper Tutorials & Examples

Dapper - Third Party Library
Dapper.SimpleCRUD

[dapper] + Enterprise Library
[enterprise-library] dapper

Use Dapper.NET ORM in ASP.NET MVC

短小精悍的.NET ORM神器 -- Dapper
Dapper小技巧：以資料表保存集合物件JSON
由 Dapper 傳回 dynamic 物件取得欄位清單

Dapper ＋Oracle 之 DateTime 注意事項

OracleParameter 型別不符導致 ORA-03111 通訊中斷錯誤

[料理佳餚] Dapper 自定義欄位對應的三種方式

好用的微型 ORM：Dapper
[.NET]輕量又兼具效能的ORM Framework - Dapper
輕型的ORM類Dapper
给力分享新的ORM => Dapper
Dapper的一些BUG的修复和扩展
关于Dapper的一些使用和扩展的例子
A Look at Dapper.NET
Dapper.NET Tutorial
Creating a Data Repository using Dapper: 10 Years of .Net Compressed into Weeks #12
RepositoryWrapper.Dapper



Making Dapper Faster with Transactions
Bulk inserts taking longer than expected using Dapper
how perform batch operation with dapper orm?
SqlBulkCopy for Generic List (useful for Entity Framework & NHibernate)
SqlBulkCopy 類別



Can't get multi-mapping to work in Dapper
Help with Multi-Mapper to create object hierarchy
Is there an equivalent to “NotMapped” for Dapper.Net and the Dapper.Net extensions?
Manually Map column names with class properties

Data Access Extension Method

Building A Dapper Glimpse Plugin
Glimpse 1.7+ with Dapper Profiling
Getting the SQL and Parameters out of Dapper for display in Glimpse

SQL Server Dapper *** Helper class to mitigate working with Dapper against SQL Server database
POCO Generator

---

Evaluating ORMs for Batch Data Performance
Followup on ORMs for Batch Performance
Fetch performance of various .NET ORM / Data-access frameworks

---

Dapper – Micro ORM for Oracle and Microsoft .NET read Oracle cursor
OracleDynamicParameters.cs

---

Kuick Application & ORM Framework

PetaPoco A tiny ORM-ish thing for your POCOs

AutoMapper

Getting Started Guide
AutoMapperSamples

MRKT AutoMapper

Can Automapper be used in a console application?

Using AutoMapper: Getting Started
Using AutoMapper: Creating Mappings
Using AutoMapper: Mapping Instances

Conditional mapping
Custom value resolvers
Null substitution

Translating Objects of One Type to Another with AutoMapper ***** 整理的很詳細
Automapper: Mapping objects

Conditionally overwrite destination if no destination object is used
AutoMapper settings properties to null on destination object

AutoMapper 兩個物件對映到一個類別
Automapper convert from multiple sources
automapper multi objects to one object
How to configure automapper to map from two source objects to a destination object?
(若用在List上可能沒效)

使用AutoMapper做物件複製，注意仍需要做CreateMap，不然會取到Source物件的參考。
Copy object to object (with Automapper ?)

Mapper.Map()是全域的，若要動態建立規則，要使用ConfigurationStore
Different mapping rules for same entity types in AutoMapper
Using the instance version of CreateMap and Map with a WCF service?

opt.UseValue(value)是靜態方法，會使用相同的值。
AutoMapper Tip: DateTime and UseValue don’t mix
AutoMapper: UseValue vs ResolveUsing vs MapFrom
AutoMapper使用简单总结

AutoMapper: “Ignore the rest”?

AutoMapper registration in Unity DI

---

automapper update existing entity
Updating Entities from DTOs with AutoMapper
How to update an existing Entity from ViewModel using Automapper and EF4 DbContext with Lazy Loading enabled
Using Automapper to update an existing Entity POCO
Why mapping DTOs to Entities using AutoMapper and EntityFramework is horrible

---

Using AutoMapper to prevent SELECT N+1 problems
Using AutoMapper to perform LINQ aggregations
Projecting computed properties with LINQ and AutoMapper


Using AutoMapper to copy Metadata from Entities to ViewModels

CRUD Opearations using AutoMapper in an MVC Application

---

AutoMapper 3加入了对开放式泛型以及回调的支持
AutoMapper以及创建跨平台的程序集

ORM

[.NET]透過 T4 產生對應 DB table 的 entity

Building Biggy: Resolving Dissonance Between Domain Objects and Backing Store Entities
Biggy介绍：一个面向文档数据库的类ORM库

---

NHibernate Setup for ASP.NET
Fluent NHibernate Tutorial | C# Windows CRUD Example

---

Telerik OpenAccess ORM

OpenAccess ORM for Oracle 實戰演練
第六屆鐵人賽文章索引-OpenAccess ORM for Oracle 實戰演練

---

NPoco a fork of PetaPoco

PetaPoco
PetaPoco：适用于.NET的微型ORM
PetaPoco入门(一）
PetaPoco入门(二）

Petapoco 连接oracle11g 自动生成poco时遇到的问题


POCO Generator

---

AutoPoco
每周源代码58-用AutoPoco和Entity Framework Code First生成（数据库）测试数据

---

EntityFramework Reverse POCO Generator

---

DbExtensions

---

RawDataAccessBencher

---

DatabaseSchemaReader

SQLite參考

Using the SQLite database engine with Windows Phone 8 apps
[EntLib]微軟企業庫5.0 學習之路——第三步、為項目加上異常處理（採用自定義擴展方式記錄到數據庫中）
使用log4net完成程序異常日誌記錄（使用SQLite數據庫記錄和普通文本記錄）

Make your SQLite bulk inserts very fast in C# .NET
Improve performance of SQLite bulk inserts using Dapper ORM

SQLite Performance and Prepared Statements

SQLite in WPF with Entity Framework 6

Cross-Platform SQLite Support – Part 1

SQLitePCL Now Supports Universal Windows Apps!

Windows Phone 8.0, Phone 8.1, Windows 8.1–Experiments Accessing SQLite

Local Database SQLite For Windows 10

Android高效入門—SQLite資料庫

SQLite基础学习

---

Telerik OpenAccess ORM