-
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 ...
-
Hello All, We have developed a set of C# templates, which have now been used with a few of Angel’s ASP.NET/SQL Server based products. Please feel free to use and criticize the templates, which we hope you will find helpful. The templates create a, Data Layer Data Abstraction Layer GUI Layer Business...
-
.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...
-
The problem is that generated code should look like: .... SELECT @ReturnedConcurrencyTimestamp = [CONCURRENCY_TIMESTAMP] FROM [dbo] . [T_SOME_TABLE] WHERE [SOME_TABLE_ID] = @SomeTableId .... But it looks like .... SELECT @ReturnedConcurrencyTimestamp = [ConcurrencyTimestamp] FROM [dbo] . [T_SOME_TABLE...
-
I'd like to see the update routines only update the fields that have been modified. As it is, I need to ensure that I have either gotten the record from the database, update the data, and then update the database; or that I have gotten all fields from the client application. Right now, we're...
-
Try the patch attached to this post, i think it is caused by the lack of a lock on the indexer property, this simple patch just ensures the hashtables are initialized fully before being accessed. Please let us know if this fixes your issue, so that it may be incorporated into the release by the .netTiers...
-
Hi, Hope someone can help here. I'm running a scheduled app to process multiple databases at once. It's designed to be multithreading and for the most part it works fine. The problem is that every so often I get the following error when processing one of the databases; System.ApplicationException...
-
Hello, In nettiers we have : Tlist for tables + Tlist for its custom stored procedures. Vlist for views and for procs returning having the same resultset as for the view. But very often we use stored procedures to do some custom logic and return a resultset. We have several procedures for the logical...
-
This feature request is broken into two parts, the latter being dependant on the former: I've been thinking about how nice it would be if properties were indexed by name, e.g. MyEntity["Name"]. This would allow for easier use of entities in generic code, and would eliminate the need for...
-
Hi, I have a problem with a custom stored procedure. It does not return Dataset anymore (worked fine until now) when I am calling it from the Service of the entity which belongs. Stored Procedure : CREATE PROCEDURE [dbo].[usp_Material_FindMaterial_Like] @Code as nvarchar(50) AS BEGIN SET NOCOUNT ON;...