primary-key
NHibernate on a table with two "primary" keys
I\'m learning NHibernate in order to layer it over a rather peculiar legacy database.Other applications use the same live database, so I can\'t make changes that will affect them.[详细]
2023-03-16 11:55 分类:问答Subselect, joins and O/R mapping
i am following struts 2 and hibernate 5. I have two tables A and B with different primary keys A_ID and B_ID.[详细]
2023-03-15 15:24 分类:问答How does the Data Type of an SQL table's PK impact query performance?
How does the Data Type of an SQL table\'s PK impact query performance? Specifically, I am interested in:[详细]
2023-03-15 15:00 分类:问答Information schema and Primary Keys
How do I just print out a \'primary key\' for the column with the primary key? I get \'primary key\' for all the columns if the table has a primary key, instead of the one column with the primary ke[详细]
2023-03-15 14:42 分类:问答SQL Server - Selecting a Primary Key for my table
I have a table that stores user info. In the User table, username开发者_开发技巧 is unique. Do you think I should make username as primarykey or should I use a surrogate key that is an int?[详细]
2023-03-15 14:03 分类:问答Should I use a surrogate key (id= 1) or natural primary key (tag='sqlalchemy') for my sqlalchemy model?
On the database side, I gather that a natural primary key is preferable as long as it\'s not prohibitively long, which can cause indexing performance problems.But as I\'m reading through projects that[详细]
2023-03-14 14:38 分类:问答how do I save to a database record with the primary key value = 0?
I have a client\'s database that I am accessing with nHibernate.In one table, they have a primary key which auto-increments starting at 0.I cannot have the client\'s database changed to a 1 based auto[详细]
2023-03-14 12:58 分类:问答Database PK-FK design for future-effective-date entries?
Ultimately I\'m going to convert this into a Hibernate/JPA design. But I wanted to start out from purely a database perspective. We have various tables containing data that is future-effective-dated.[详细]
2023-03-14 07:10 分类:问答How to change value of primary key and update foreign key in the same time
I have a record in table with wrong primary key. I want change 开发者_Python百科it tocorrect value, but this value is used in many other tables.[详细]
2023-03-14 03:27 分类:问答When we pass a primary-key to UI, should not it be considered as mixing of 2 layers and a BAD practice?
When we pass a Db identifier of any object to the UI (Let\'s say the PrimaryKey of an object in the url query string) aren\'t we mixing two layers (Persistnet layer and presentation layer) basically?[详细]
2023-03-13 22:38 分类:问答