How to import from excel to multi relational SQL server tables using LINQ C#?

Question

1.44/5 (2 votes)

See more:

I have an excel sheet has data like this

EmployeeName | CityName | JobName
jalal| monaco| officer
ali | paris | doctor

and I have three sql server tables

Employee table
ID
EmployeeName
City_ID
Job_ID

City table
ID
CityName

Job table
ID
JobName

Assuming that the three tables are empty.

I want to Import the excel sheet to the three table using LINQ to SQL and C#
And Export from Three Tables To excel sheet . Can Any one Help please?

What I have tried:

I don t know anything about importing and exporting data using LINQ C#

Posted 3-Feb-24 8:38am

jrkl jrkl

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

M Imran Ansari · Answer 1 · 2024-02-03T09:01:00

Consult the provided links below for guidance on how to import/export data to/from SQL using LINQ. These articles offer a detailed, step-by-step explanation, you can write the query according to your table structure.
Importing Excel XLS Files to Database Tables using Linq to SQL[^]
Entity Model to Excel using LINQ in C#[^]