StrataFrame Forum » StrataFrame Application Framework - V1 » Business Objects and Data Access (How do I?) » BO Mapper DateTime C# Settings Issue

BO Mapper DateTime C# Settings Issue

Jeff Pagley — Thu, 30 Sep 2010 19:41:12 GMT

I have been using Strataframe/VB.NET for some time now. But I have been ask to develop an C#/ASP.NET Web app. So I am new to all that. I am trying to setup my field settings in the BO Mapper where I am assigning for my date fields the value of #1/1/1800# for Return Alternate on Null / Set Null on .... option. C# code generated shows the compiler error 'Preprocesor directives must appear as the first non-whitespace character on a line.' for the following code:

if (value != #1/1/1800#)

What is wrong? Also, in addition to this, is there anything else I need to be aware of when using C# vs VB.NET is setting up the BO Mapper stuff?

Thanks,

Jeff

RE: BO Mapper DateTime C# Settings Issue

Greg McGuffey — Thu, 30 Sep 2010 19:41:12 GMT

Glad it helped Jeff! And I used the chart Ivan posted [b]a lot[/b] when I was learning C# after having programmed in VB.NET for a couple of years.

RE: BO Mapper DateTime C# Settings Issue

Ivan George Borges — Thu, 30 Sep 2010 18:21:53 GMT

That is great, Jeff. Hope it helps. ;)

RE: BO Mapper DateTime C# Settings Issue

Edhy Rijo — Thu, 30 Sep 2010 16:15:12 GMT

Your are welcome Jeff!

RE: BO Mapper DateTime C# Settings Issue

Jeff Pagley — Thu, 30 Sep 2010 14:18:22 GMT

Thanks Edhy/Greg that did the trick. BTW Ivan the comparison chart is very helpful. Thanks!

RE: BO Mapper DateTime C# Settings Issue

Greg McGuffey — Thu, 30 Sep 2010 11:58:35 GMT

The primary concept to understand is that the BOMapper is going to put whatever you type into the replacement value directly into code. Thus it must be valid for the language being used by the BO. VB.NET has the date literal (#1/1/1800#) but C# does not. I use the method Edhy suggested myself, though it has to be valid C# so it has to be:

[code]new DateTime(1800, 1, 1)[/code]

No semi-colon needed as it is inserted into lines of code, but the [b]new[/b] keyword is lower case in C#.

RE: BO Mapper DateTime C# Settings Issue

Ivan George Borges — Thu, 30 Sep 2010 10:27:07 GMT

I think you could also use DateTime.Parse("1/1/1800 00:00:00")

Here is a good comparison chart that could be handy for you:

http://www.harding.edu/fmccown/vbnet_csharp_comparison.html

RE: BO Mapper DateTime C# Settings Issue

Edhy Rijo — Thu, 30 Sep 2010 09:30:29 GMT

Hi Jeff,

Instead of using a literal in the Return Alternate on Null, try something like this:
[quote]New DateTime(1800, 1, 1)[/quote]