Browse by Tags

Hierarchical data and 5th normal form(Design help needed)

I am working with HIPAA Taxonomy codes. 5 tables are involved as a base. Before we really begin, this is an integration project, the original data sits in a db2 database and the structure is untouchable. Since taxonomy data is pretty static we are creating a SQL version in our application. the structure...

Posted to .netTiers - General Support (Forum) by ecathell on 05-30-2007
Filed under: Database
Help: Entity Update Problem ?

Hi I have the following code running AfterInsert of a DataSource control. What I'm trying to achieve is set the value MasterShow_Pk equal to a value. The code runs fine but the Data Store is not being updated with the value. protected void _x_ShowsDataSource_AfterInserted( object sender, x.Web.Data....

Posted to .netTiers - General Support (Forum) by matt@kiwilamb.com on 05-27-2007
Filed under: .netTiers, EntityDataSource, DataSource, Entities, Database
Database Encryption

Using Sql Server 2005 I have encrypted certain columns in the database using symmetric key encryption by password. To decrypt and encrypt, with each open connection I need to wrap my queries with “open symmetric key HappyKey DECRYPTION BY password = ‘happypassword’” and “close all symmetric keys” before...

Posted to .netTiers - General Support (Forum) by kuhn on 03-28-2007
Filed under: Encryption, Database
Identity Columns

I have an issue with Nettiers. I wish to copy database records from one database to another database using .Nettiers data layer. However when creating the new record in the receiving database I wish to keep the same Identity column value. How would I do this using .net tiers? What I'm trying to do...

Posted to .netTiers - General Support (Forum) by matt@kiwilamb.com on 06-13-2007
Filed under: .netTiers, Multiple Databases, Data Layer SqlClient, Database
How can i use 2 database in one application

in our application , there is only one sqlserver database in used. when customer view a report page ,it need run many sql query and cause system became slow. to avoid this problem ,we try to duplicate data to another sqlserver database ,and try to run query in that database. so, the question is how can...

Posted to .netTiers - General Support (Forum) by simonHong on 11-07-2007
Filed under: Data Layer SqlClient, Database
External stored procedures as custom stored procedures

Hello, I'm using a custom stored procedure calling an external assembly. The type of the SP is 'PC' rather than the regular 'P' (if I remember well). .nettiers could not pick it up and I had to create another custom SP calling the external one. Is there a way to make .nettiers pick...

Posted to .netTiers - General Support (Forum) by R4cOOn on 12-07-2007
Filed under: .netTiers, Custom Stored Procedure, NetTiers.cst, Database, .net 3.0, custom stored Procedured procedure, Custom Stored Procedure error, database GAC
Switching kind of connection at runtime

I'm new to netTiers. I want to use them in an application that has the following context. There will be users running this app over a LAN (this users would use the standard DAL to access data) and there will be others users that will use this app on WAN, so this users would use a web service to access...

Posted to .netTiers - General Support (Forum) by torlica on 01-11-2008
Filed under: ConnectionString, Configuration, .net 2.0, Database, switching connection mode
Composite Keys and m:mRelationships

My Question is as follows. what would be the best practice in database, for a webbased application, using .NetTiers as my DAL? Sorry If I posted in the wrong thread. 1 - Conventions PrimaryKey (PK) , ForeignKey (FK), Employer-> Company,Organization , Branch -> Company Branch, ContactPerson ->...

Posted to .netTiers - Tips/Tricks (Forum) by FireLin on 03-30-2008
Filed under: References, .NetTiers, Database, DAL
Hierarchical db relationships as BLL

I'm sure this has been asked and probably answered before but I'm not finding anything. I have two database tables that are hierarchically related (a 1:1 relationship). For the sake of argument, let's call them Person and Employee. Person has fields like name and address. An Employee is also...

Posted to .netTiers - Tips/Tricks (Forum) by cms on 04-11-2008
Filed under: Database, bll
Basic Data Question

Hi all, Basic .NETTIERS question. If i need to exclude certain fields in an insert or update how do i go about doing this in nettiers. Do i have to write my own procedure and have it wrapped into the generated .nettiers api? An example of doing this may be, say CreatedDt would be populated on insert...

Posted to .netTiers - General Support (Forum) by adamjknight on 05-12-2008
Filed under: .netTiers, Custom Stored Procedure, Entities Service object at run time, Database, DataRepository

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