public void Generic_DbRawSqlQuery_ToString_returns_the_query_but_not_the_parameters() { var query = new DbRawSqlQuery <FakeEntity>( MockHelper.CreateInternalSqlSetQuery("select * from Products where Id < {0} and CategoryId = '{1}'", 4, "Beverages")); Assert.Equal("select * from Products where Id < {0} and CategoryId = '{1}'", query.ToString()); }
public void Non_entity_SQL_query_GetList_throws_indicating_that_binding_to_queries_is_not_allowed() { var query = new DbRawSqlQuery <Random>(MockHelper.CreateInternalSqlNonSetQuery("query")); Assert.Equal( Strings.DbQuery_BindingToDbQueryNotSupported, Assert.Throws <NotSupportedException>(() => ((IListSource)query).GetList()).Message); }
public void Generic_DbSqlQuery_ToString_returns_the_query_but_not_the_parameters() { var query = new DbRawSqlQuery<FakeEntity>( MockHelper.CreateInternalSqlSetQuery("select * from Products where Id < {0} and CategoryId = '{1}'", 4, "Beverages")); Assert.Equal("select * from Products where Id < {0} and CategoryId = '{1}'", query.ToString()); }
public void MaxAsync_throws_OperationCanceledException_if_task_is_cancelled() { var query = new DbRawSqlQuery <FakeEntity>(MockHelper.CreateInternalSqlNonSetQuery("select * from products")); Assert.Throws <OperationCanceledException>( () => query.MaxAsync(new CancellationToken(canceled: true)) .GetAwaiter().GetResult()); }
public void Non_generic_ToListAsync_throws_OperationCanceledException_if_task_is_cancelled() { var query = new DbRawSqlQuery(MockHelper.CreateInternalSqlSetQuery("query", false, 1, 2)); Assert.Throws <OperationCanceledException>( () => query.ToListAsync(new CancellationToken(canceled: true)) .GetAwaiter().GetResult()); }
public void ToDictionaryAsync_throws_OperationCanceledException_if_task_is_cancelled() { var query = new DbRawSqlQuery <FakeEntity>(MockHelper.CreateInternalSqlNonSetQuery("select * from products")); Assert.Throws <OperationCanceledException>( () => query.ToDictionaryAsync(n => n, new CancellationToken(canceled: true)) .GetAwaiter().GetResult()); Assert.Throws <OperationCanceledException>( () => query.ToDictionaryAsync(n => n, n => n, new CancellationToken(canceled: true)) .GetAwaiter().GetResult()); var equalityComparer = new Mock <IEqualityComparer <FakeEntity> >().Object; Assert.Throws <OperationCanceledException>( () => query.ToDictionaryAsync(n => n, equalityComparer, new CancellationToken(canceled: true)) .GetAwaiter().GetResult()); Assert.Throws <OperationCanceledException>( () => query.ToDictionaryAsync(n => n, n => n, equalityComparer, new CancellationToken(canceled: true)) .GetAwaiter().GetResult()); }
public ActionResult Login(string userName, string password) { // var query = (from Users in db.UsersContext where dbUsers.kullaniciAdi==userName select dbUsers.kullaniciSifresi); try { data1 = db.UsersContext.SqlQuery("select * from Users where kullaniciSifresi=@p0", password); // data1 = db.Database.SqlQuery<Users>("select * from Users where kullaniciSifresi=@p0", password); foreach (var custinfo in data1) { a = custinfo.kullaniciAdi.ToString(); b = custinfo.kullaniciSifresi.ToString(); } //var User = from m in db.UsersContext select m; //User = User.Where(s => s.kullaniciSifresi.Contains(password)); //foreach (var custinfo in User) //{ // a = custinfo.kullaniciAdi.ToString(); // b = custinfo.kullaniciSifresi.ToString(); //} } catch(Exception x) { x.Message.ToString(); } try { if (a.Equals(userName) && b.Equals(password)) { Session["user"] = new Users() { kullaniciAdi = Convert.ToInt32(a), kullaniciSifresi = b }; return RedirectToAction("Index"); } } catch { } return View(); }
public void DbRawSqlQuery_ContainsListCollection_returns_false() { var query = new DbRawSqlQuery <FakeEntity>(MockHelper.CreateInternalSqlSetQuery("query")); Assert.False(((IListSource)query).ContainsListCollection); }
public void Generic_DbRawSqlQuery_ToString_returns_the_query() { var query = new DbRawSqlQuery <FakeEntity>(MockHelper.CreateInternalSqlSetQuery("select * from products")); Assert.Equal("select * from products", query.ToString()); }
public void DbSqlQuery_ContainsListCollection_returns_false() { var query = new DbRawSqlQuery<FakeEntity>(MockHelper.CreateInternalSqlSetQuery("query")); Assert.False(((IListSource)query).ContainsListCollection); }
public void Non_entity_SQL_query_GetList_throws_indicating_that_binding_to_queries_is_not_allowed() { var query = new DbRawSqlQuery<Random>(MockHelper.CreateInternalSqlNonSetQuery("query")); Assert.Equal( Strings.DbQuery_BindingToDbQueryNotSupported, Assert.Throws<NotSupportedException>(() => ((IListSource)query).GetList()).Message); }
public void Generic_DbSqlQuery_ToString_returns_the_query() { var query = new DbRawSqlQuery<FakeEntity>(MockHelper.CreateInternalSqlSetQuery("select * from products")); Assert.Equal("select * from products", query.ToString()); }
public void Non_generic_DbSqlQuery_AsStreaming_returns_new_object_with_streaming_flag_set() { var query = new DbRawSqlQuery(MockHelper.CreateInternalSqlSetQuery("query", false, 1, 2)); DynamicAsStreamingTest(query); }