Re: Error when trying to run NetTiers in CodeSmith v5

Are you using a Mappiing File?  Is the path to the Mapping file valid?  The line number above points to it trying to create a mapping file or something to do with the mapping file.

Also, silly question, but you do have the Framework 2.0 installed.  I am assuming you do, but since the error is could not load type, I figure I would make sure.  Not sure if it is a pre-req of codesmith 5 or not.

This is definetely an error I have not seen before.

jeff

I am new to CodeSmith and NetTiers so please bear with my ignorance...

I do have Framework 2.0 installed (v2.0.50727) as well as 1.1 and 3.0.

When I look at the mapping file specified in the parameter "MappingFile", it looks like it gets partially created. 

Here is what is in the mapping file once i receive the error:

<?xml version="1.0" encoding="utf-8"?>
<NetTiersMap xmlns="http://www.nettiers.com/NetTiersMap.xsd">
 <Table Id="CHANGE_DETAIL" EntityName="ChangeDetail" Owner="dbo" PropertyName="ChangeDetail" FieldName="_changeDetail" FriendlyName="Change Detail" IncludeInOutput="true">
  <Column Id="CHANGE_DETAIL_ID" CSType=" 

 The column that it stopped on is just an int identity field.  Even if I change the tables that it uses, I still get the error and the same output in the mapping file (except that the table and fieldnames are different.).

Hello,

That datatype you are using is new to .net 3.5.

"System.DateTimeOffset: DateTimeOffset is a new date time data structure that specifies an exact point in time relative to the UTC time zone".

I would set the .net version in the .netTiers template to .net 3.5, vs2008, and enterprise library to v4, delete the corrupt mapping file, and Download .net 3.5 (with service pack 1).

Thanks
-Blake Niemyjski

Why do we have the option of using .net 2.0, vs2005 then if it only works with .net 3.5?  I do not use vs2008 or .net 3.5.  I want the code generated for .net 2.0 and vs2005.  I have all the parameters in CodeSmith set to v2 and vs2005.

Hello,

We give users the choice of what they want to use. However, that is totally dependent on what your targeting (schema wise, etc....) For example you wouldn't necessarily generate a SQL Server 2008 specific database and target .net 1.1...

I would attach a debugger at the following line and see why it is blowing up...

at MoM.Templates.CommonSqlCode.GetCSType(DataObjectBase field, Boolean nullable) in e:\CodeSmith\Samples\v5.0\Templates\Frameworks\NetTiers\TemplateLib\CommonSqlCode.cs:line 3559

If you are unable to find the cause please send me the version of .netTiers you are using and your .csp, and sql schema and I will take a look at this issue.

Thanks
-Blake Niemyjski

I downloaded the latest version (2.2) and still get the same error.  I attached the debugger and stopped at the section of code where the error occurs...

The code is trying to get "field.SystemType.ToString()" where field is a variable of type "SchemaExplorer.DataObjectBase".  Here is what the variable field contains :

field.AllowDBNull = false

field.DataType = Int32

field.NativeType = "int"

field.Precision = 10

field.Scale = 0

field.Size = 4

field.SystemType = Throws the "System.TypeLoadException"

Obviously, this is where the problem is, but how can I look at the definition of the field.SystemType to see why it is failing?

Hello,

You can't step into that really because you don't have the CodeSmith source code. If you send me your sql schema I will take a look and debug this issue. Could you please attach or email (BNiemyjski@codesmithtools.com) the schema to me along with your break point information.

Thanks
-Blake Niemyjski

I have built another test database and it works perfectly.  I am currently trying to determine what is different between the databases. 

Hello,

Please keep me updated on what the cause of the issue was.

Thanks
-Blake Niemyjski

Hello,

I'm getting the same error. Has anyone been able to resolve the problem?

Thanks in advance!

Dieter

Hello all,

When I try to run nettiers in codesmith professional 5.0, I get the following error:

System.TypeLoadException: Could not load type 'System.DateTimeOffset' from assembly

Has anyone also had the same problem and been able to solve it?

Help would be very much appreciated!

Thanks in advance!

Sincerely,

Dieter

Hello,

I've been really trying to resolve this error but I can't repo it on any machine. Can you tell what operating system your using. The version of CodeSmith, .netTiers and SQL Server you are using. Also what versions of the .Net framework do you have installed? Any chance of you emailing me your sql schema so I can see if I can repo this with your schema.

Thanks
-Blake Niemyjski

Hello,

If you send me your sql schema I will take a look. Could you please attach or email (BNiemyjski@codesmithtools.com).

Thanks
-Blake Niemyjski

Hello Blake,

I've been away for a long weekend, so it's a bit of a late reaction :-)

It's codesmith Professional 5.0, netTiers-2[1].2.0, SQL Server 2005 SP2 and .Net Framework 2.0 (with visual studio 2005).

When I run codesmith, the mappingfile stops at the first (data)row of the first table to generate. And the first field is not even a datetime field!

I will see what I can do for the schema... Thanks in advance for your efforts!

Dieter