tags:

views:

16

answers:

0
+1  Q: 

Suppressing LINQ to SQL DBML warnings

I've generated LINQ to SQL classes from a database not under my control which has a lot of Decimal(38, 5) fields. Apparently the range of the .NET Decimal type is smaller than this, so the LINQ to SQL code generator is throwing a lot of warnings:

DBML1008: Mapping between DbType 'Decimal(38,5)' and Type 'System.Decimal' in Column 'StructGable24InchOCStuds' of Type 'AddersAndMultiplier' may cause data loss when loading from the database

It's extremely unlikely that any of these fields will ever have a value big enough to cause data loss in practice so I'd like to suppress these warnings. However, apparently setting warning suppression through the dialog in VS doesn't work with LINQ to SQL code generator warnings - is there another method?

related questions

What is the syntax for an inner join in linq to sql?
Best Practices for Managing Linq to SQL Dbml Files?
Best use pattern for a DataContext
Is there a pattern using Linq to dynamically create a filter?
Can you use LINQ tools such as SQLMetal with an access database?
How to Track Queries on a Linq-to-sql DataContext
Linq To SQL: Can I eager load only one field in a joined table?
What causes Visual Studio to fail to load an assembly incorrectly?
NHibernate vs LINQ to SQL
Linq 2 SQL on shared host
Attaching entities to data contexts
XRef Relationships in dbml
Linq to SQL - Underlying Column Length
Learning about LINQ
LINQ to SQL Mapping From Money to Double
LINQ-to-SQL vs stored procedures?
Has anyone had any success in unit testing SQL stored procedures?
Best .NET Solution for Frequently Changed Database
Conditional Linq Queries
Entity Framework vs LINQ to SQL
When should I use Compiled LINQ vs Normal LINQ
LINQ to SQL strings to enums
How much database performance overhead when using LINQ?
LinqDataSource - Can you limit the amount of records returned?
Are Multiple DataContext classes ever appropriate?