EF Bulk Insert to SQL Server table with UNIQUEIDENTIFIER column as primary keyAdd a column with a default value to an existing table in SQL ServerHow to check if a column exists in a SQL Server table?Check if table exists in SQL ServerInserting multiple rows in a single SQL query?Insert results of a stored procedure into a temporary tableWhat is the best way to auto-generate INSERT statements for a SQL Server table?How do I UPDATE from a SELECT in SQL Server?Find all tables containing column with specified name - MS SQL ServerWhat are the best practices for using a GUID as a primary key, specifically regarding performance?Reset identity seed after deleting records in SQL Server
Drawing ramified coverings with tikz
How should I respond when I lied about my education and the company finds out through background check?
What is Cash Advance APR?
The screen of my macbook suddenly broken down how can I do to recover
Should I stop contributing to retirement accounts?
Is a bound state a stationary state?
Is it possible to have a strip of cold climate in the middle of a planet?
How to explain what's wrong with this application of the chain rule?
What should you do when eye contact makes your subordinate uncomfortable?
250 Floor Tower
How can we generalize the fact of finite dimensional vector space to an infinte dimensional case?
Loading commands from file
Creepy dinosaur pc game identification
Should I outline or discovery write my stories?
Where did Heinlein say "Once you get to Earth orbit, you're halfway to anywhere in the Solar System"?
Why did the HMS Bounty go back to a time when whales are already rare?
How do you respond to a colleague from another team when they're wrongly expecting that you'll help them?
Count the occurrence of each unique word in the file
Which one is correct as adjective “protruding” or “protruded”?
Approximating irrational number to rational number
Melting point of aspirin, contradicting sources
Offered money to buy a house, seller is asking for more to cover gap between their listing and mortgage owed
Fear of getting stuck on one programming language / technology that is not used in my country
Why is it that I can sometimes guess the next note?
EF Bulk Insert to SQL Server table with UNIQUEIDENTIFIER column as primary key
Add a column with a default value to an existing table in SQL ServerHow to check if a column exists in a SQL Server table?Check if table exists in SQL ServerInserting multiple rows in a single SQL query?Insert results of a stored procedure into a temporary tableWhat is the best way to auto-generate INSERT statements for a SQL Server table?How do I UPDATE from a SELECT in SQL Server?Find all tables containing column with specified name - MS SQL ServerWhat are the best practices for using a GUID as a primary key, specifically regarding performance?Reset identity seed after deleting records in SQL Server
I am working on an ASP.NET C# web application with Entity Framework and a SQL Server 2017 database.
There is a Transaction table with a UNIQUEIDENTIFIER column as its primary key and this key is being using as a foreign key to refer to from a child table.
I am using the EF bulk insert function to insert bulk data into both the tables simultaneously.
Is there a way to generate the GUID value from my C# code and insert the same on UNIQUEIDENTIFIER columns on both tables?
c# .net
sql-server entity-framework uniqueidentifier edited Mar 8 at 6:03
marc_s
582k13011231269
asked Mar 8 at 5:03
George ThomasGeorge Thomas
206
add a comment |
I am working on an ASP.NET C# web application with Entity Framework and a SQL Server 2017 database.
There is a Transaction table with a UNIQUEIDENTIFIER column as its primary key and this key is being using as a foreign key to refer to from a child table.
I am using the EF bulk insert function to insert bulk data into both the tables simultaneously.
Is there a way to generate the GUID value from my C# code and insert the same on UNIQUEIDENTIFIER columns on both tables?
c# .net
sql-server entity-framework uniqueidentifier edited Mar 8 at 6:03
marc_s
582k13011231269
asked Mar 8 at 5:03
George ThomasGeorge Thomas
206
Get a guid value usingGuid.NewGuid()and use that for the related rows.
– Dan Guzman
Mar 8 at 5:14
add a comment |
I am working on an ASP.NET C# web application with Entity Framework and a SQL Server 2017 database.
There is a Transaction table with a UNIQUEIDENTIFIER column as its primary key and this key is being using as a foreign key to refer to from a child table.
I am using the EF bulk insert function to insert bulk data into both the tables simultaneously.
Is there a way to generate the GUID value from my C# code and insert the same on UNIQUEIDENTIFIER columns on both tables?
c# .net
sql-server entity-framework uniqueidentifier edited Mar 8 at 6:03
marc_s
582k13011231269
asked Mar 8 at 5:03
George ThomasGeorge Thomas
206
I am working on an ASP.NET C# web application with Entity Framework and a SQL Server 2017 database.
There is a Transaction table with a UNIQUEIDENTIFIER column as its primary key and this key is being using as a foreign key to refer to from a child table.
I am using the EF bulk insert function to insert bulk data into both the tables simultaneously.
Is there a way to generate the GUID value from my C# code and insert the same on UNIQUEIDENTIFIER columns on both tables?
c# .net
sql-server entity-framework uniqueidentifier c# .net
sql-server entity-framework uniqueidentifier edited Mar 8 at 6:03
marc_s
582k13011231269
asked Mar 8 at 5:03
George ThomasGeorge Thomas
206
edited Mar 8 at 6:03
marc_s
582k13011231269
asked Mar 8 at 5:03
George ThomasGeorge Thomas
206
edited Mar 8 at 6:03
marc_s
582k13011231269
edited Mar 8 at 6:03
marc_s
582k13011231269
edited Mar 8 at 6:03
marc_s
582k13011231269
582k13011231269
asked Mar 8 at 5:03
George ThomasGeorge Thomas
206
asked Mar 8 at 5:03
George ThomasGeorge Thomas
206
asked Mar 8 at 5:03
George ThomasGeorge Thomas
206
206
Get a guid value usingGuid.NewGuid()and use that for the related rows.
– Dan Guzman
Mar 8 at 5:14
add a comment |
Get a guid value usingGuid.NewGuid()and use that for the related rows.
– Dan Guzman
Mar 8 at 5:14
Get a guid value using
Guid.NewGuid() and use that for the related rows.– Dan Guzman
Mar 8 at 5:14
Get a guid value using
Guid.NewGuid() and use that for the related rows.– Dan Guzman
Mar 8 at 5:14
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function()
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled)
StackExchange.using("snippets", function()
createEditor();
);
else
createEditor();
);
function createEditor()
StackExchange.prepareEditor(
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader:
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
,
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
);
);
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55057016%2fef-bulk-insert-to-sql-server-table-with-uniqueidentifier-column-as-primary-key%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55057016%2fef-bulk-insert-to-sql-server-table-with-uniqueidentifier-column-as-primary-key%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Get a guid value using
Guid.NewGuid()and use that for the related rows.– Dan Guzman
Mar 8 at 5:14