Everyone came over to our house on Sunday for a Memorial day party.  We had a good showing: McKnights X 2, Bavermans, Brunners, Merzs, Weigands, Meiners and a few others.  The meal was a pork tenderloin that we marinated for 24 hours.  It was fantastic. 

The kids all had fun riding their bikes, scooters, tri-cycles and other toys.  The adults enjoyed their share of alcoholic beverages.  You can tell we are getting old though - everyone was gone by 21:00!

Kathleen, Carson and I spent the day with the Merz family for Maisie's 4th birthday.  The theme was pirates and princesses.  Kathleen dressed up as Sleeping Beauty and Carson wore an eye patch.  We had an entire pirate outfit for him but he did not cooperate. 

Happy birthday Maisie!

We recently upgraded to Visual Studio 2008.  Everything seemed to be running fine after the upgrade, except our crystal reports.  We received this error:

Exception Info: Could not load file or assembly 'CrystalDecisions.CrystalReports.Engine, Version=10.5.3700.0, Culture=neutral, PublicKeyToken=692fbea5521e1304' or one of its dependencies. The system cannot find the file specified.

Crystal Reports for Visual Studio 2008 requires a "runtime" to load reports on a client machine.  This "runtime" can be found in this location on a development machine: C:\Program Files\Microsoft SDKs\Windows\v6.0A\Bootstrapper\Packages\CrystalReports10_5

There is a 32 and 64 bit version.  We installed the correct version on our web servers.  It did not require a restart, but the dll would not load until we actually did a restart.  After the restart, everything functioned normally.

I found this post on Microsoft's forums detailing the issue.

We use LLBL in all of our applications.  It is an extremely powerful tool and the support is fantastic. 

In my current site log project for DNN we need to aggregate data such that we have date as the X and Number of hits as the Y.  Therefore, we needed to group by date which is made possible in LLBL by using an expression. 

   1: [Serializable]

   2:     public class FunctionExpression : Expression

   3:     {

   4:         #region class member declarations

   5:         private string _functionToApply;

   6:         #endregion

   7:  

   8:         public FunctionExpression()

   9:             : base()

  10:         {

  11:             _functionToApply = string.Empty;

  12:         }

  13:  

  14:         /// Selfservicing constructor.All other constructors are hidden, we only work on a single field.

  15:         public FunctionExpression(IEntityField field, string functionToApply)

  16:             : base(field)

  17:         {

  18:             _functionToApply = functionToApply;

  19:         }

  20:  

  21:         /// Adapter constructor. All other constructors are hidden, we only work on a single field.

  22:         public FunctionExpression(IEntityField2 field, string functionToApply)

  23:             : base(field)

  24:         {

  25:             _functionToApply = functionToApply;

  26:         }

  27:  

  28:  

  29:         public override string ToQueryText(ref int uniqueMarker, bool inHavingClause)

  30:         {

  31:             if (_functionToApply.Length > 0)

  32:             {

  33:                 return string.Format("{0}({1})", _functionToApply, base.ToQueryText(ref uniqueMarker, inHavingClause));

  34:             }

  35:             else

  36:             {

  37:                 return base.ToQueryText(ref uniqueMarker, inHavingClause);

  38:             }

  39:         }

  40:  

  41:  

  42:         #region properties

  43:         public string FunctionToApply

  44:         {

  45:             get { return _functionToApply; }

  46:             set { _functionToApply = value; }

  47:         }

  48:         #endregion

  49:     }

You then have to create your field and apply the expression to the field.

   1: fields[12] = SiteLogFields.DateTime;

   2: fields[12].ExpressionToApply = new FunctionExpression(EntityFieldFactory.Create(SiteLogFieldIndex.DateTime), "[dbo].[FetchDate]");

And the simple fetch date function in sql:

   1: FUNCTION [dbo].[FetchDate]  

   2:      (  

   3:           @inDateTime     datetime  

   4:      )  

   5: RETURNS datetime  

   6: AS  

   7:      BEGIN  

   8:           DECLARE @tempString     varchar(20)  

   9:           DECLARE @tempDate     datetime  

  10:           SET @tempString = CONVERT(varchar(20), @inDateTime, 101)  

  11:           SET @tempDate = CONVERT(datetime,@tempString)  

  12:      RETURN @tempDate  

  13:      END   

I'm probably jinxing myself, but Cooper has been very easy to take care of thus far.  Kathleen and Carson are adjusting well.  It helped that I had the week off work and could spend ample time with each of them. 

We went on a bike ride everyday this week.  Kathleen is proving to be quite the rider.  Her and Isabel rode up and down the street for hours last night.  Carson wants to do everything big sister is doing, but he is content with his tricycle for now.

Cooper and Kim are great.  He wakes up twice a night to eat, which is wonderful.  He sleeps in the crib by our bed.   This same bed is occupied by Kim, me, the 2 kids and the dog by the end of the night!