Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public async Task<List<KeyValuePair<string, string>>> WithoutDapper(Guid id)
- {
- using (var connection = new SqlConnection(ConnectionString))
- {
- List<KeyValuePair<string, string>> propertiesList = new List<KeyValuePair<string, string>>();
- SqlCommand command = new SqlCommand(queryString, connection);
- command.Parameters.AddWithValue("Id", id);
- connection.Open();
- SqlDataReader reader = await command.ExecuteReaderAsync();
- if (reader.HasRows)
- {
- while (reader.Read())
- {
- propertiesList.Add(new KeyValuePair<string, string>(
- reader["Name"].ToString(),
- reader["Type"].ToString()));
- }
- }
- return propertiesList;
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement