Пример #1
0
 public SqlServerQuery(string connString, EntityFactory entityFactory, IDataLocationCache dataLocationCache)
 {
     _connString        = connString;
     _entityFactory     = entityFactory;
     _dataLocationCache = dataLocationCache;
 }
Пример #2
0
 public SelectOneQuery(string connString, EntityFactory entityFactory, IDataLocationCache dataLocationCache)
     : base(connString, entityFactory, dataLocationCache)
 {
     _query = $"SELECT TOP 1 * FROM [DATALOCATION]";
 }
Пример #3
0
        public SelectManyQuery(int count, string connString, EntityFactory entityFactory, IDataLocationCache dataLocationCache)
            : base(connString, entityFactory, dataLocationCache)
        {
            var num = count != 0 ? $"TOP {count}" : "";

            _query = $"SELECT {num} * FROM [DATALOCATION]";
        }
Пример #4
0
 public UpdateQuery(string connString, EntityFactory entityFactory, IDataLocationCache dataLocationCache)
     : base(connString, entityFactory, dataLocationCache)
 {
     _query = $"UPDATE [DATALOCATION]";
 }
Пример #5
0
 public DeleteManyQuery(string connString, EntityFactory entityFactory, IDataLocationCache dataLocationCache)
     : base(connString, entityFactory, dataLocationCache)
 {
     _query = $"DELETE FROM [DATALOCATION]";
 }
Пример #6
0
 public InsertQuery(string connString, EntityFactory entityFactory, IDataLocationCache dataLocationCache)
     : base(connString, entityFactory, dataLocationCache)
 {
     _query = $"INSERT INTO [DATALOCATION] ([COLUMNS]) VALUES ([VALUES])";
 }