Browse by Tags

.netTiers

.netTiers are CodeSmith templates for object-relational mapping that takes an existing SQLServer database and automatically generates a personnalized Data Tiers application block to use in your .Net applications. Core features include: Generates ready to use Visual Studio projects and solution. Fully...

Posted to Templates (FileGallery) by dSquared on 12-19-2005
Filed under: Data Access Layer, Stored Procedures, C#, SQL
CRUD template for the SqlNetFramework

Hi, I would like to share a CRUD template for the SqlNetFramework. The SqlNetFramework allows you to work with SQL very easy. You only specifies the SQL code and the parameters, if any. The SQL is stored in an external repository (XML, DB) it allows you to re-use your SQL code in any application supported...

Posted to Template Share (Forum) by Luis E. Ramirez on 04-22-2007
Filed under: DAL, SQL, SqlNetFramework
Re: Custom Stored Procedures are being erased.

I initially used "_{0}_" as custom store's format string, tried later with "sp_{0}_" and problems repeats. I create a "Clients" table with "IdClient" , "Name" and "BirthDate" columns. Then i make a custom store named "sp_Clients_Show"...

Posted to .netTiers - General Support (Forum) by ManuX on 06-28-2007
Filed under: .netTiers, Custom Stored Procedure, .net 2.0, SQL
Custom Stored Procedures are being erased.

I have a problem with Nettiers version 2.0.1.471. It's easy to reproduce. 1) Create a table with a column named "colX" 2) Create a Custom Stored Procedure that specify the name of the "colX" in the order by clause (for example) 3) Generate and everything will be OK 4) Drop the...

Posted to .netTiers - General Support (Forum) by nachobornan on 06-25-2007
Filed under: .netTiers, Custom Stored Procedure, .net 2.0, SQL, custom stored Procedured procedure
Scripting a SQL Server database to be compatible with SQL Server Compact Edition

Out of necessity, I created this template to help me move a SQL Server 2005 database to SQL Server 2005 Compact edition. This saved me a LOT of manual entry for all the DDL for the CREATE TABLE stuff. Right now all it does is the basic create table with primary key (if any). It doesn't do foreign...

Posted to Template Share (Forum) by Hector on 07-07-2007
Filed under: SQL, SQL Server Compact Edition, SQL Server
SQL Syntax Standards

Please standardize the SQL syntax. http://msdn2.microsoft.com/en-us/library/ms189826.aspx Find_Dynamic uses mixed case for "Create Table", upper case for the first "SELECT", and lower case for the last "select". Get_List uses "SELECT" then "Select". Etc...

Posted to .netTiers - General Support (Forum) by mcgmatt on 07-26-2007
Filed under: SQL, syntax
SQL Server Audit Tables and Triggers

CreateAuditTablesAndTriggers.cst creates audit tables and triggers for the selected tables. Uses a one audit table per source table strategy. Timestamp columns are ignored. <cheese>To get around a SQL Server issue with text and ntext columns in the "inserted" and "deleted" tables...

Posted to Templates (FileGallery) by Jamison on 08-24-2007
Filed under: SQL, sql server, auditing, audit table, audit trigger
.netTiers Usage Scenario

We have created several small client applications with .netTiers and have been very happy with the templates. We are now looking at using .netTiers with out internal CRM application and we are seeing some areas where we might have some issues. Scenario 1: When adding a new appointment (and many other...

Posted to .netTiers - General Support (Forum) by lordh on 09-20-2007
Filed under: .netTiers, CRUD, alias, stored proc, SQL, base class
NEW: Database Explorer API (DB Schema API) Released!

Greetings If you've been looking for a Database Schema API that is a bit more intuitive than the one that ships with Code Smith and one that handles relationships such as 1:1, 1:M, M:1, M:M and recursion and also has a built in expression parser, then do yourself a favour and check this new API out...

Posted to Template Share (Forum) by dotNetProfessional on 03-17-2008
Filed under: DAL+, DAL, SQL, SQL Server, .Net 2.0
Using Custom Stored Procedure with Joins in Website through Data Layer?

I wrote a custom stored procedure that uses inner joins to join 2 tables and return a dataset. Nettiers recognizes that it is a custom stored procedure in my database but I have no way of accessing it through the datasource as a SelectMethod. My code for the SP is below. My goal is to use this as my...

Posted to .netTiers - General Support (Forum) by aabragan on 06-03-2008
Filed under: .netTiers, DataSource, ASp.NET, ServiceLayer, SELECT, SQL

Page 1 of 2 (19 items) 1 2 Next >