fbpx
Welcome, Guest
Username: Password: Remember me
Share your code snippets, screen shots etc. here
  • Page:
  • 1

TOPIC: LINQ to SQL - some advice on Decimal types !?

LINQ to SQL - some advice on Decimal types !? 2 years 4 months ago #1

  • Phil Hepburn
  • Phil Hepburn's Avatar Topic Author
  • Offline
  • Posts: 737
  • Karma: 7
Hi Pearl guys,

I need your help (please) with the next part of my L2S (LINQ to SQL) development.

It would appear that the query syntax for LINQ requires me to use SQL style query syntax and does not allow me to use .NET stuff in the LINQ query itself.

I have attached a few small images to show you my problem. I have a column type of 'smallmoney' which in .NET maps to a Decimal type. If I want to compare with a double 'cash' value type then I hit my problems.

Oh! and to cap it all off the .NET type is a Nullable<Decimal> needed to map to the defined SQL table column, which can be null.

HELP !! help ?? HELP !?

Nick, where are those SQL skills of yours ;-0)

Regards,
Phil.

Please Log in or Create an account to join the conversation.

LINQ to SQL - some advice on Decimal types !? 2 years 4 months ago #2

Phil,

Change the literal value to 26.13m (m = money) and it will probably compile fine.

Robert
XSharp Development Team
The Netherlands
This email address is being protected from spambots. You need JavaScript enabled to view it.

Please Log in or Create an account to join the conversation.

LINQ to SQL - some advice on Decimal types !? 2 years 4 months ago #3

  • Phil Hepburn
  • Phil Hepburn's Avatar Topic Author
  • Offline
  • Posts: 737
  • Karma: 7
Hi Robert,

Yes, many thanks, it now all works well, and I have learned a few useful things on the way to enlightenment ;-0) Like what can and can't be placed in the query code of the LINQ statement.

In fact I had discovered the 'M' myself, but had not applied it directly as you suggested I should. Then BINGO ! Success.

A couple of useful and informative attachments for those guys interested. Note the method is one defined in the 'DataContext' class - which is the class of object which sits between the SQL Tables and the .NET business class objects - like a 'bridge' it does the mapping, along with the Attributes on the business class.

Thanks again,
Phil.

Attachments:

Please Log in or Create an account to join the conversation.

  • Page:
  • 1