The NuSoft Framework

Patch Uploaded

jayjohnson — Mon, 12 May 2008 19:47:06 GMT

jayjohnson has uploaded a patch.

Description:
View my last patch ... I didn't think to modify and send the .cst.

ColumnInfo.cst (line 48&49).

Patch Uploaded

jayjohnson — Mon, 12 May 2008 19:43:16 GMT

jayjohnson has uploaded a patch.

Description:
I found an issue with default validation for datatypes using a '(max)' datatype such as 'nvarchar(max)'. SQL sets the size to -1 on those datatypes and the framework checks the max size when validating. If there is any data for a column using a '(max)' datatype it will fail since the size is greater than -1. I didn't find anything to provide me with the actual size for those types, but it appears to be the only types that have -1 for the size.

The fix is a small one, and the attached document shows the code and location for the fix. The fix code is in the red rectangle. Its a simple check that looks for a size of -1. If found it sets the max size to the max size allowed for '(max)' types found in the T-SQL documentation (http://msdn.microsoft.com/en-us/library/ms187752.aspx).

NEW POST: Problem with DB Constraint

lrr81765 — Fri, 09 May 2008 14:48:45 GMT

I am having a problem with the table creation scripts - it may be an issue with the SchemaExplorer api. I am using 4.14 of CS, and 3.0 of the nuSoft Framework.

The problem is that it is not getting all of the check constraints. The following shows 2 regions, the first is SQLDMO table script for just the constraints, the second is the frameWork generation.

Anyone else notice this ?
--region Constraints
ALTER TABLE CarrierLocality ADD
CONSTRAINT CK_CarrierLocalityCarrierNotEmpty CHECK (len(Carrier) > 0),
CONSTRAINT CK_CarrierLocalityLocalityNotEmpty CHECK (len(Locality) > 0),
CONSTRAINT CK_CarrierLocalityStateNotEmpty CHECK (len(State) > 0),
CONSTRAINT CK_CarrierLocalityUpdatedByNotEmpty CHECK (len(UpdatedBy) > 0)
GO

--region Defaults
ALTER TABLE CarrierLocality ADD
CONSTRAINT DF_CarrierLocality_IsRural DEFAULT (0) FOR IsRural,
CONSTRAINT DF_CarrierLocality_LastUpdated DEFAULT (getdate()) FOR LastUpdated,
CONSTRAINT DF_CarrierLocality_UpdatedBy DEFAULT (suser_sname()) FOR UpdatedBy
GO

--endregion

--endregion

--region Non Primary Key Constraints
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECTID(N'CKCarrierLocalityCarrierNotEmpty') AND OBJECTPROPERTY(id, N'IsConstraint') = 1)
ALTER TABLE dbo.CarrierLocality ADD
CONSTRAINT CK_CarrierLocalityCarrierNotEmpty CHECK (len(Carrier) > 0)
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECTID(N'CKCarrierLocalityStateNotEmpty') AND OBJECTPROPERTY(id, N'IsConstraint') = 1)
ALTER TABLE dbo.CarrierLocality ADD
CONSTRAINT CK_CarrierLocalityStateNotEmpty CHECK (len(State) > 0)
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECTID(N'DFCarrierLocality_IsRural') AND OBJECTPROPERTY(id, N'IsConstraint') = 1)
ALTER TABLE dbo.CarrierLocality ADD
CONSTRAINT DF_CarrierLocality_IsRural DEFAULT (0) FOR IsRural
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECTID(N'CKCarrierLocalityLocalityNotEmpty') AND OBJECTPROPERTY(id, N'IsConstraint') = 1)
ALTER TABLE dbo.CarrierLocality ADD
CONSTRAINT CK_CarrierLocalityLocalityNotEmpty CHECK (len(Locality) > 0)
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECTID(N'DFCarrierLocality_LastUpdated') AND OBJECTPROPERTY(id, N'IsConstraint') = 1)
ALTER TABLE dbo.CarrierLocality ADD
CONSTRAINT DF_CarrierLocality_LastUpdated DEFAULT (getdate()) FOR LastUpdated
GO
IF NOT EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECTID(N'DFCarrierLocality_UpdatedBy') AND OBJECTPROPERTY(id, N'IsConstraint') = 1)
ALTER TABLE dbo.CarrierLocality ADD
CONSTRAINT DF_CarrierLocality_UpdatedBy DEFAULT (suser_sname()) FOR UpdatedBy
GO

--endregion

UPDATED WIKI: Home

banderson — Tue, 22 Apr 2008 14:40:52 GMT

Welcome To The NuSoft Framework

The NuSoft Framework is an extensible business and data layer framework. It is built as a set of CodeSmith templates. The templates generate a strongly typed C# domain model based off your SQL 2005 database schemas. Our code framework is a great way to get a custom development project off the ground on the right foot.

Background

The NuSoft framework was developed by Kinetic IG at RCM Technologies over many years and different types of projects (mostly large web applications). We are happy to be able to share the combined experiences of our consulting related to custom development frameworks with our clients and now the .Net open source community. Why The NuSoft Framework?

Documentation

Get up to speed by using our reference documentation including a simple 3 step "How To" guide and advanced topics material. We also have a rough project Road Map if you are interested in our future development plans. We monitor the discussions so please don't hesitate to ask questions.

Code Samples

We now have a team that has started producing code samples for NuSoft Framework working against the AdventureWorks database. It is a constant work in progress. You can download the source at the The NuSoft Framework Samples.

Technical Requirements

In order to run these templates you will need to use CodeSmith v4 or greater. It costs $99 for their standard editon. There is a free trial version for 30 days which is plenty of time to get you going. The framework is designed to run against SQL 2005 databases.

Consulting Services

Kinetic IG at RCM Technologies is a Microsoft National Systems Integrator and Certified Gold consulting partner. We provide a full range of consulting services related to our code framework including a significant focus on building large web applications. If you are interested in leveraging our consulting services please contact Bruce Benson via email bbenson@nusoftsolutions.com or by phone at 616-954-9556 x116.

UPDATED WIKI: Home

banderson — Tue, 22 Apr 2008 14:38:35 GMT

Welcome To The NuSoft Framework

Background

Documentation

Code Samples

Technical Requirements

Consulting Services

NEW POST: Access ReturnValue in the Inserted event of an ObjectDataSource.

SvanurK — Fri, 11 Apr 2008 10:10:33 GMT

Hello Ross!
Thank you for your reply.

I noticed that your Insert and Update procedures return a @table with all inserted/updated values in a single row. Would it be possible to return this data as an object?
Then I could get this object from the ObjectDataSourceStatusEventArgs.ReturnValue property of an 'Inserted' event and cast it to the object I'm working with.

At least it would be great to have the PrimaryKey returned:)

Thanks,
Svanur.

NEW POST: Access ReturnValue in the Inserted event of an ObjectDataSource.

RossCode — Fri, 11 Apr 2008 03:51:19 GMT

SvanurK,

It doesn't sound like you are doing anything wrong. This looks like a bug in the framework. I will look into it, and fix it.

Thanks for the catch.

Joel

NEW POST: Access ReturnValue in the Inserted event of an ObjectDataSource.

SvanurK — Wed, 09 Apr 2008 15:24:45 GMT

Hi there!

I am using a DetailsView + ObjectDataSource to insert a new row to database using the generated 'Insert' function.
In the 'Inserted' event of the ObjectDataSource I want to check if my data was saved to db or not using the ReturnValue property of the ObjectDataSourceStatusEventArgs.
But this value is always null because the generated Insert method returns void instead of int as the Execute method does.

If I change the Insert function in the generated code so it returns int instead of void I can access it's result in the ReturnValue property in the 'Inserted' event of the ObjectDataSource. But of course I dont want to change the generated code.

Am I doing this the wrong way?

UPDATED RELEASE: NuSoft Framework 3.0 (Apr 03, 2008)

Tue, 08 Apr 2008 13:08:50 GMT

NuSoft Framework 3.0 includes the following new features:

* *Validation Support*: We added validation of properties to determine if fields are required and that strings are less than the max length. This is extendable through overrides and events, so you can add your own validations pretty easily.
* *Logging Support*: This was one of those things we struggled with. We didn't want to add a dependency in the framework to a particular logging framework, so instead of adding logging support directly, we added the hooks so you could log what you wanted to log. Most of what we could come up with had to do with logging SQL queries, so we made the SqlHelper a partial class and added a base class, so you could add the logging by overriding OnExecuting and OnExecuted.
* *Database-based Paging and sorting*: We've added a bunch of overloads to Get[Entity]() methods to allow you to page at the database level.
We also fixed a few bugs that were brought to our attention. Documentation is a bit lite right now, but we're working on it!

UPDATED RELEASE: NuSoft Framework 3.0 (Apr 03, 2008)

Fri, 04 Apr 2008 03:17:00 GMT

This will include (as of yet unidentified) major new features from V 2.x

CLOSED ISSUE: _isNullable property in the ColumnInfo object is always false

RossCode — Fri, 04 Apr 2008 03:16:22 GMT

While using the NuSoft Framework I have noticed that the _isNullable property on the ColumnInfo object is always false. This causes validation errors when trying to save an entity that has a not mandatory String amongst its properties.

To resolve this issue I have added:

if (reader["IS_NULLABLE"].ToString() == "YES")
{
_isNullable = true;
}

in the constructor of the ColumnInfo class. Furthermore, I have also altered the GetValidationErrors method of the EntityBase class as in the attachment.

This solution means however that the nullable property is database driven not DataObjectField attribute driven. Any additional solution/comments are more then welcome!

I am using changeset 15851.

Regards,
Comments: Version release.

CLOSED ISSUE: Primary Key Columns with Name "ID"

RossCode — Fri, 04 Apr 2008 03:16:22 GMT

Hi All

I look after a database which has the convention of using "ID" as the Primary Key for all columns.

In using the Nusoft Framework (15770), I have set extended properties for all the columns to be "TableName + Id" which works nicely until the GetColumnNameWithoutIdSuffix function is called in entity.generated.cst which returns "" for the ColumnName.

Can I suggest the following fix?

public string GetColumnNameWithoutIdSuffix(ColumnSchema column)
{
string name = "";
string columnName = column.Name;
if(column.ExtendedProperties["NSFx_EntityPropertyName"] != null) {
columnName = (string)column.ExtendedProperties["NSFx_EntityPropertyName"].Value;
}

if(columnName.EndsWith("id", System.StringComparison.CurrentCultureIgnoreCase))
{
name = GetPascalCaseName(columnName.Substring(0, columnName.Length - 2));
}
else
{
name = GetPascalCaseName(columnName);
}
return name;
}
Comments: Version release.

CLOSED ISSUE: Excluded Tables Not Working Correctly

RossCode — Fri, 04 Apr 2008 03:16:21 GMT

Relationships to excluded tables doesn't appear to be ignored as they should be.
Comments: Version release.

CLOSED FEATURE: Add Paging support to queries

RossCode — Fri, 04 Apr 2008 03:16:21 GMT

This should be database based paging and also support custom sorting.
Comments: Version release.

CLOSED FEATURE: Add Refresh Method to Entities

RossCode — Fri, 04 Apr 2008 03:16:20 GMT

Allow for entities to be refreshed from the database through a simple method call.
Comments: Version release.

CLOSED FEATURE: Add Logging Support

RossCode — Fri, 04 Apr 2008 03:16:20 GMT

Add logging support. Should be through a provider and be an optional include.
Comments: Version release.

CLOSED FEATURE: Add Validation Support

RossCode — Fri, 04 Apr 2008 03:16:19 GMT

Add validation support for entities. This should be an option, as it will require a third party library. We will validate null/not null, as well as length of strings, while giving users the ability to add their own custom validations.
Comments: Version release.

CLOSED FEATURE: Set Entity Defaults based on Database Default Values

RossCode — Fri, 04 Apr 2008 03:16:19 GMT

We should read the database for default values and use those as default property values when creating a new entity.
Comments: Version release.

CLOSED FEATURE: Enhance FindEntity and FindEntities to work like EntityComparer

RossCode — Fri, 04 Apr 2008 03:16:18 GMT

EntityComparer works with multiple properties, but FindEntity and FindEntities does not. They should be changed so they work more alike.
Comments: Version release.

CLOSED ISSUE: Issues with Composite Foreign Key Relationships

RossCode — Fri, 04 Apr 2008 03:16:18 GMT

There is a naming conflict with composite foreign key relationships when you have multiple relationships to the same table. There is also some potential naming conflicts that need to be resolved.
Comments: Version release.