I'm starting using EF 6 alpha 3 code.
I encounter the following issue when I try to build the database on SQL Azure by using the Update-Database command:...In this version of SQL Server, tables without clustered indexes are not supported. Please try again after creating a clustered index....The sql command used to create the __MigrationHistory tabl...
Change in response to the new failure mode (too many results). All to Any:... result = result.Where(t => searchTextArray.All(s => t.title.ToLower().Contains(s)));
In my.NET Core application, I want to use LINQ to get data from several tables. Here's an illustration:...public class Customer {
public Guid Id { get; set; }
public string Name { get; set; }
public DateTime Created { get; set; }
public HashSet<Transaction> Transactions { get; set; }
}
public class Transaction {
public Guid Id...
I can make an invoke expression using SQL functions, as shown below....var likeMethod = typeof(DbFunctionsExtensions).GetMethod("Like", new[] { typeof(DbFunctions), typeof(string), typeof(string) });
Expression.Call(null, likeMethod, Expression.Constant(EF.Functions), searchKeyExpression, Expression.Constant($"%{filter.Value}%"));
...The only thin...
