Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Problem with MM.Net Business Layer Generator and SAOLEDB
Message
From
20/09/2008 17:59:27
 
 
To
All
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Title:
Problem with MM.Net Business Layer Generator and SAOLEDB
Environment versions
Environment:
C# 2.0
OS:
Vista
Network:
Windows 2008 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01349247
Message ID:
01349247
Views:
69
Hi,


I tested the Business Layer Generator with 3 OleDB connections to 3 NorthWind databases, respectively MS Sql Server (Native Client SQLNCLI), VFP (VFPOLEDB) and Sql Anywhere (SAOLEDB).
Without any problems all 3 connections show up at the VS Server Explorer.
For the EmployeeID, LastName, table, BirthDate and Photo fields of the Employee table, I get the following Data Types in the VS Server explorer:
			VFP	(VFPOLEDB)					ASA (SAOLEDB     OleDB)								MS SQL Native Client (SQLNCLI  OleDB)

EmployeeID		OleDbType.Integer, Nullable False, Precision 4		OleDbType.Integer, Nullable False, Precision (not specified)			OleDbType.Integer, Nullable False, Precision 10
LastName		OleDbType.Char,Length 20, Nullable False		OleDbType.WChar,Length 20, Nullable False					OleDbType.WChar,Length 20, Nullable False
BirthDate		OleDbType.DBDate, Nullable true				OleDbType.DBTimeStamp, Nullable true						OleDbType.DBTimeStamp, Nullable true
Photo			OleDbType.Binary, Length 2147483647, Nullable True	OleDbType.Binary, Length 2147483647, Nullable True				OleDbType.Binary, Length 2147483647, Nullable True
When I run the MM.Net Business Layer Generator on the Sql Anywhere connection, the generated EmployeeEntity contains all Properties, Fields and cast without Data Type (replaced by question Mark)
E.g. for the Address property:
/// <summary>
/// Address
/// </summary>
public ? Address
{
	get
	{
		if (this.Row != null)
		return (?)mmType.GetNullableDbValue(this.Row["Address"]);
		else
		return this._address;
	}
	set
	{
	if (this.Row != null)
	this.Row["Address"] = mmType.SetNullableDbValue(value); 
	this._address = value;
	this.OnPropertyChanged(new PropertyChangedEventArgs("Address"));
	}
}
private ? _address;
Any clues why this happens and (when applicable) where I can tweak the Business Layer Generator ?

Thanks in advance,

Mark
If everything seems to be going well, you obviously don't know what the hell is going on !
Reply
Map
View

Click here to load this message in the networking platform