-
Notifications
You must be signed in to change notification settings - Fork 5
/
BaseRepository.cs
73 lines (62 loc) · 2.29 KB
/
BaseRepository.cs
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Reflection;
using Dapper;
namespace DapperGenericRepository.Repositories
{
public abstract class BaseRepository<T>
{
protected string connectionString = @"<CONNECTION STRING HERE>";
public virtual void Insert(T entity)
{
var columns = GetColumns();
var stringOfColumns = string.Join(", ", columns);
var stringOfParameters = string.Join(", ", columns.Select(e => "@" + e));
var query = $"insert into {typeof(T).Name}s ({stringOfColumns}) values ({stringOfParameters})";
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
connection.Execute(query, entity);
}
}
public virtual void Delete(T entity)
{
var query = $"delete from {typeof(T).Name}s where Id = @Id";
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
connection.Execute(query, entity);
}
}
public virtual void Update(T entity)
{
var columns = GetColumns();
var stringOfColumns = string.Join(", ", columns.Select(e => $"{e} = @{e}"));
var query = $"update {typeof(T).Name}s set {stringOfColumns} where Id = @Id";
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
connection.Execute(query, entity);
}
}
public virtual IEnumerable<T> Query(string where = null)
{
var query = $"select * from {typeof(T).Name}s ";
if (!string.IsNullOrWhiteSpace(where))
query += where;
using (var connection = new SqlConnection(connectionString))
{
connection.Open();
return connection.Query<T>(query);
}
}
private IEnumerable<string> GetColumns()
{
return typeof(T)
.GetProperties()
.Where(e => e.Name != "Id" && !e.PropertyType.GetTypeInfo().IsGenericType)
.Select(e => e.Name);
}
}
}