Login User data comes from Database

Question

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' } };

Sachin Singh · 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; }

Asma Khalid · Answer

Use entity framework database first approach i.e. https://bit.ly/2QUkDNH Thanks & Regards, Asma Khalid

Login User data comes from Database

Answers (2)