My sql server database table has Guid as primary key (Id) column and default as newid(), when making an insert to the table using entity core, if i dont supply the Id field i would like the insert ...

There's a report that our current client-side sequential GUIDs generator for SQL Server doesn't work well for concurrent environments; #30753 was opened to consider switching to server-generated GUIDs ...

As far as size and scalability… in SQL Server, an int is 4 Bytes and can hold roughly 2 Billion positive unique numbers, bigint is 8 Bytes and can hold about 9.2 Quintillion (9,223,372,036,854,775,808 ...