Recent changes to bugs

Small bug in CsGenerator class

2013-05-26T16:27:44.160000Z

Thanks for your wonderful tool.

I've found a small bug near line 182 of the file CsGenerator.cs

streamWriter.WriteLine("\t\t\tthis." + Utility.FormatCamel(column.Name) +
" = " + Utility.FormatCamel(column.Name) + ";");

but it should be:
streamWriter.WriteLine("\t\t\tthis." + Utility.FormatPascal(column.Name) +
" = " + Utility.FormatCamel(column.Name) + ";");

CreateMockClass namespace

2009-02-04T14:20:54Z

version 4.3

namespace MyNamespace..Mock

bug: streamWriter.WriteLine("namespace " + targetNamespace + "." + daoSuffix + ".Mocks");

fix: streamWriter.WriteLine("namespace " + targetNamespace + (daoSuffix == string.Empty ? string.Empty : "." + daoSuffix) + ".Mocks");

CreateDataAccessClass namespace error

2009-02-04T13:38:42Z

when u don't write a DAO Suffix u get this in the generated code:

namespace MyNamspace.

VS display error: 'Indentifier expected'

bug: streamWriter.WriteLine("namespace " + targetNamespace + "." + daoSuffix);

fix: streamWriter.WriteLine("namespace " + targetNamespace + (daoSuffix == string.Empty ? string.Empty : "." + daoSuffix));

this eliminate the '.' at the end of the namespace.

Too many open connections in DB

2007-09-06T08:14:22Z

All the connections caused by SQL ExecuteReader are not closed. So the Connection Pool of the SQL Server can exceed the limit.

Example actually:

public static Table Select(short table_ID)
{
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader("tablesSelect", table_ID))
{
if (dataReader.Read()) {
return MakeTable(dataReader);
} else {
return null;
}
}
}

Should be:

public static Table Select(short table_ID)
{
using (SqlDataReader dataReader = SqlClientUtility.ExecuteReader("tablesSelect", table__ID))
{
if (dataReader.Read()) {
Table returnTable = MakeTable(dataReader);
dataReader.Close();
return returnTable ;
} else {
return null;
}
}
}

Double for Float

2007-04-13T14:51:37Z

There is a type descrepency when a float data type is found in the database.

The fields are established as Double but the make method uses GetFloat which throws an invalid cast exception.

Xml Datatype not supported

2007-03-23T21:32:06Z

The Xml datatype for sql server 2005 is not included in the types list.

C# Class Generation Not Including the requested SP Prefix

2007-03-20T21:07:15Z

On version 4.2 the following methods in the C# classes are not including the requested stored procedure prefix in the ExecuteNonQuery call.

Insert
Update
Delete
Select
SelectAll

Thanks for the great work, this is going to save me lots of time.

Marc

bad zip

2006-03-13T12:26:56Z

the zip is corupted
! \\Galx\datastor\Downloads\DataTierGenerator.zip:
Unexpected end of archive

ofergal@gmail.com

Stream: Parameter can\'t be null! error

2005-04-03T14:25:23Z

Can somebody help me?
When I try to run the application I got this message
Stream: Parameter can't be null!
What can I do?
How to fix the problem?
Thanks!

Version 2.1.1 (Stored Proc Naming)

2005-01-28T06:21:47Z

the C# code that gets generated uses the method name
as the stored procedure name - instead it's supposed to
use the "procedureName" string on line 390 in
method "CreateSelectByMethods" - "CsGenerator.cs".

another problem is some of the SQL procedures are
named diffrent than the stored procedure name(S) in
the generated C# code.
so i get a stored procedure X does not exist error.