Andrew Bancroft • 3/29/2017

Entity Framework Tip – Specifying Decimal Precision

Read Original

This article explains a common issue in Entity Framework where .NET decimal types are mapped to SQL Server's decimal(18,2) by default, causing truncation of values with greater precision. It provides a step-by-step guide to override the OnModelCreating method in DbContext and use the HasPrecision() method to set custom decimal precision and scale. The tutorial is aimed at developers using Entity Framework Code First and includes a code example for clarity. It emphasizes understanding over copying code.

0 comments
#c #SQL Server #Entity Framework
Entity Framework Tip – Specifying Decimal Precision

Comments

No comments yet

Be the first to share your thoughts!

Browser Extension

Get instant access to AllDevBlogs from your browser

Top of the Week

1
Limit token usage in Microsoft Agent Framework
Jesse Liberty • 1 votes
2
How to Roll Back AI Agents: Incident Response, Circuit Breakers, and Recovery Patterns
Paul Bryant • 1 votes
3
Avoiding Reasoning Model Failures with Microsoft Foundry
Luke Murray • 1 votes
4
When Your AI Agent Lies: Silent LLM Fallbacks
Luke Murray • 1 votes
5
Adding a custom MCP server to Claude and ChatGPT
Simon Willison • 1 votes
6
Testing AI prompts and comparing models with promptfoo
Tim Deschryver • 1 votes
7
Superlogical
Mitchell Hashimoto • 1 votes