Skip to content

Searcharticlesvideosblogsforumsinterview questionsarticles

Tech
Articles
Blogs
News
Videos
Interviews
Forums
Books
Events
- Jobs
- Stories

Article
Blog
Video
Ebook
Interview Question

Loading

Upcoming Events

23 NOV
AI Agents Conference 2026 - 3rd Edition

Our Training Programs

AI & Machine Learning
Mastering Large Language Models
Mastering Prompt Engineering
Certified Vibe Coder
Github Copilot Training
Generative AI for Beginners
n8n Automation & AI Agents Training

About Us Contact Us Privacy Policy Terms Brand Guidelines Partners C# Tutorials Consultants Ideas Report A Bug FAQs Sitemap Stories CSharp TV DB Talks Web3 Universe Jumpstart Blockchain

©2026 C# Corner.

All contents are copyright of their authors.

Login User data comes from Database

Home
Forums
.NET

Login User data comes from Database

selvi jp

5yAsked Jun 2, 2021, 6:27 AM758.NET

Here i give manually user data. but I want to userdata comes from database. How to connect db in .net core

private List users = new List()
{
new User{
EmployeeId=24,EmployeeName="selvi",Password="111111"}
};

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sign in to answer this question

It is the same account you read, post and publish with — and you will come straight back to this page.

Sign in Create an account

Sachin Singh5y ago
Accepted answer
To communicate to the database you have multiple options and are all applicable with .net Core.
Ado.Net
EntityFramework Core
Dapper
Ado.Net
public List GetAll()
{
using(SqlConnection con=new SqlConnection("yourconnectionstring"))
{
SqlCommand cmd= new SqlCommand("select * from table",con);

con.Open();
var rdr= cmd.ExecuteReader();
List users= new List();
while(rdr.Read())
{
User user= new User();
user.Name=rdr["Name"].ToString();
user.Password= rdr["Password"].ToString();
user.Id=Convert.ToInt32( rdr["Id"]);
users.Add(user);
}

return users;
}
EFCore (Context object is coming from dependency injection)
public List Get()
{

return _context.Users.ToList();
}
Dapper
public List Get()
{
string query= "SELECT  * FROM tbl_User;";
List users= new List();

using (var connection = new SqlConnection("connectionstring"))
{
     users= connection.Query(query).ToList();

}
return users;
}
+2
Asma Khalid5y ago
Use entity framework database first approach i.e. https://bit.ly/2QUkDNH

Thanks & Regards,
Asma Khalid
0