Should I use an int or a long for the primary key in an entity framework model

c# entity-framework-6 int model primary-key

Question

I am writing an MVC5 Internet application and I have a question about the id field for a model.

Should I use an int or a long for the id in a model? I am talking about the field that is used for the primary key? Is an int enough if the database has 100,000s of records? Is an int in c# different than an int in a SQL database?

Thanks in advance

1
13
7/21/2014 3:46:36 AM

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge

Accepted Answer

Both are OK. It depends on how many records will be in a table. Int allows only 2*10^9 records per table.

If you are sure, that 2*10^9 is enough, use int as a key.

But: If there is a tiny chance that count of records will be more than 2*10^9, use the long. If you don't have any idea how many records you'll have, use long.

3
7/21/2014 3:55:10 AM

Popular Answer

With a type INT, starting at 1, you get over 2 billion possible rows - that should be more than sufficient for the vast majority of cases. With BIGINT, you get roughly 922 quadrillion (922 with 15 zeros - 922'000 billions) - enough for you??

If you use an INT IDENTITY starting at 1, and you insert one row every second, around the clock, you need 66.5 years before you hit the 2 billion limit ....

If you use a BIGINT IDENTITY (BIGINT in T-SQL is defined as long or Int64 in .NET languages) starting at 1, and you insert one thousand rows every second, you need a mind-boggling 292 million years before you hit the 922 quadrillion limit ....

Read more about it (with all the options there are) in the MSDN Books Online.

marc_s

Related Questions

Entity Framework Code First Using One column as Primary Key and another as Auto Increment Column

You can also do this with Data Annotations:...public class Sale { [DatabaseGenerated(DatabaseGeneratedOption.Identity)] public int Id { get; set; } [Key] public string TrNo { get; set; } public DateTime Date { get; set; } public int CustomerID { get; set; } public ObservableCollection<SaleDetail> SaleDetails { get; se...
c# ef-code-first entity-framework
asked by Corey Adler

Entity Framework Foreign Key as Primary Key Code First

I thought I'd give this a shot and it worked nicely....public class FooState { [Required] [Key] [ForeignKey("Foo")] public int FooStateId { get; set; } [Required] public int State { get; set; } public Foo Foo { get; set; } }
c# ef-code-first entity-framework
asked by Neil

Code Generation : Add primary key / foreign key to Entity Framework

I ran into the same problem. The template file you are looking for appears in the Solution Explorer (in VS2013) as:...YourDataModelName.tt...You can modify it to add the ...[Key]... attributes to the generated code by following:...Finding a property is Primary Key in POCO Template t4 generator
c# code-generation entity-framework-6
asked by srg39

Entity Framework 6.1.3 Mapping Foreign key to non primary key

This is now possible in Entity Framework 7 (that is, EF Core 1.0)....From .Net Entity Framework User Voice ...Unique Constraint (i.e. Candidate Key) Support...:...Support for this feature was added in EF Core 1.0 and we don’t have plans to add it in the EF6 codebase.
c# entity-framework-6
asked by ErikE

Violation of PRIMARY KEY constraint with Entity Framework 6 , Model one-to-many

You are correct - the second instance won't know you just added the customer. Either wrap them in the same using statement or you can tell the second instance the customer already exists:...var user = new User(); user.Id = Guid.NewGuid(); user.Name = "username"; using (var db = new DbContext()) { user.Customer = new Customer() { Id = custom...
c# code-first entity-framework-6
asked by Steve Greene

Entity Framework code-first set foreign key with primary key in same table

This answer for your requirement of 2 foreign keys ...public class WdUser : SysDomainModelBase, IWdUser { //This is your primary key of WDUser public int UserID{get;set;} //This is for your 1st foreign key mapping public virtual WDUser WDUser{get;set;} public virtual ICollection<WDUser> WDUserList{get;set;} public int fk1{get;set;} //This is for y...
asp.net c# entity-framework-6
asked by Nithila Shanmugananthan

Entity Framework, Load multiple entities by primary key in a single query while still using caching

Not implicitly....Where()... will always query the database. To explicit query the cache you need to use ....Local...: ...dbContext.Entity.Local.Where(......This will not hit the database but it will only return entities that have been cached/loaded before....Good to know: to view the queries define a Log function like this: ...dbContext.Database.L...
.net c# entity-framework entity-framework-6
asked by Chris

Entity Framework composite key delete with one primary key

If you are using EF 6, you can use the RemoveRange method....So it could look something like this;...context.Cart.RemoveRange(cartItem => cartItem.CustomerID == CustomerToDelete);
c# entity-framework-6 repository-pattern
asked by feal

Entity Framework foreign key that is not a primary key

I wanted to switch from only IDs to GUIDs for uniqueness and changed the tables. ...You don't really need to switch to GUIDs to ensure uniqueness.Your IDs will be guaranteed to be unique (whichever type they are, say integer) as long as they are set as your primary keys....I have read that GUIDs as primary keys are not recommended for performance r...
c# entity-framework entity-framework-6 guid sql
asked by Jan Paolo Go

Post request to database associated with primary and foreign key in web api using Entity Framework

If you want to insert one row in MeterInfoes Table....public class MeterInfo { [Key] public int MeterId { get; set; } public string MeterName { get; set; } public int? FloorId { get; set; } [ForeignKey("FloorId")] public FloorInfo FloorInfo { get; set; } } ...Add your entities to DbContext, if not d...
asp.net-web-api asp.net-web-api2 asp.net-web-api-routing entity-framework-6 post
asked by Hasta Tamang

Fastest Entity Framework Extensions

Bulk Insert
Bulk Delete
Bulk Update
Bulk Merge
View more on Stack Overflow

Prime Library

Performance

Expression Evaluator

More Projects...

Related

Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow
Licensed under: CC-BY-SA with attribution
Not affiliated with Stack Overflow