Browse Site by Tags - CodeSmith Community

Generated SQL: ANSI NULLS : SET TO OFF BY DEFAULT

Hi, By default .nettiers generates all stored procedures with ANSI NULLS set to OFF. e.g SET ANSI_NULLS OFF We are using a SQL Server 2005 Indexed View, which must use SET ANSI_NULLS ON for any CRUD operations. I understand that using ANSI_NULLS OFF specifies SQL-92 compliant behavior of the Equals ...

Posted to .netTiers - General Support (Forum) by james.smith@adactus.co.uk on 06-26-2008
Filed under: .netTiers, SQL View 2005, ANSI_NULLS, stored procedures, ansi nulls, sql server

Stored Procedure Related

Hello I am a first time user of Code-Smith. I am testing version 4.0 with .NetTiers template. I have a database with some tables and some stored procedures. I use this tool to generate DAL code for the entire DB. But i dont see any code related to my stored procedure. How can i get my stored procedures...

Posted to Community Support (Forum) by kamal109 on 02-22-2008
Filed under: .netTiers, SQL View 2005

Views and schema

Hello, I'm using views with .nettiers and I've ran into some problems. As long as the views are in the default schema (dbo), .nettiers works fine. If the views are in a different schema, .nettiers picks up the views fine and creates the stored procs with the correct schema information. The problem...

Posted to Community Support (Forum) by R4cOOn on 12-06-2007
Filed under: .netTiers, nettiers, SQL View 2005

Generating Insert/Update/Delete Stored Procedures from an SQL 2005 View

Using the CodeSmith explorer, it doesn't display database views when trying to generate stored procedures. Is there any work around for this?

Posted to Community Support (Forum) by Stephen Hender on 10-17-2007
Filed under: SQL View 2005