Npgsql is the .NET data provider for Postgresql. It allows any program developed for .NET framework to access a Postgresql database server. It is implemented in 100% C# code. Postgresql versions since 9.0 are officially supported, others may work.
55000: prepared transactions are disabled but i don't want enable prepared transactions
Hello guys, I am aware NpSQL is shipped with Power BI. sadly this is only the 4.0.1 version of NpgSQL, where I need the newer 4.1.x version in order to support FOREIGN TABLEs. The MS documentation shows it takes the CAG installed NpSQL. I tried to install this through the given MSI and checking CAG installation, however I still do not seem to get the correct tables.
Does anybody know if Power BI can be supported with NpgSQL 4.1.x?
Hello All,
Any one implement unit test case for EF.Functions.TrigramsAreSimilar. ? we are getting below error while running test case . any idea to solve issue?
"The 'TrigramsAreSimilar' method is not supported because the query has switched to client-evaluation. This usually happens when the arguments to the method cannot be translated to server. Rewrite the query to avoid client evaluation of arguments so that method can be translated to server."
sorry for that @roji . we implemented search functionality using EF.Functions.TrigramsAreSimilar and it's looking good. now we are trying to add unit test case for that search. er are getting below error message while running unit test method. if any one already face this issue. please share , how to fix this issue.
C# Implementation.
where(x=>EF.Functions.TrigramsAreSimilar(x.FirstName, searchText))
Error Message:
"The 'TrigramsAreSimilar' method is not supported because the query has switched to client-evaluation. This usually happens when the arguments to the method cannot be translated to server. Rewrite the query to avoid client evaluation of arguments so that method can be translated to server."
sample code:
Unit test case:
[Fact]
public void test()
{
imdbContext context = GetDBContect();
Rating rating = new Rating();
rating.AverageRating = 90;
rating.NumVotes = 90;
rating.Tconst = "TC891549";
context.Add(rating);
rating = new Rating();
rating.AverageRating = 90;
rating.NumVotes = 90;
rating.Tconst = "TC15491";
context.Add(rating);
rating = new Rating();
rating.AverageRating = 90;
rating.NumVotes = 90;
rating.Tconst = "TC15492";
context.Add(rating);
context.SaveChanges();
IMDBProvider iMDBProvider = new IMDBProvider(context);
IOrderedQueryable<Rating> ratings = iMDBProvider.GetRatings();
int ratingCount = ratings.Count();
}
private imdbContext GetDBContect()
{
DbContextOptions<imdbContext> options;
var builder = new DbContextOptionsBuilder<imdbContext>();
builder.UseInMemoryDatabase("DBTestDataBase");
options = builder.Options;
imdbContext imdbContext = new imdbContext(options);
imdbContext.Database.EnsureDeleted();
imdbContext.Database.EnsureCreated();
return imdbContext;
}Provide code to search context:
public IOrderedQueryable<Rating> GetRatings()
{
string sortedBy = "AverageRating";
return _context.Ratings
.Where(x => EF.Functions.TrigramsAreSimilar(x.Tconst, "1549") ||
EF.Functions.TrigramsAreSimilar(x.NumVotes.ToString(), "1549"))
.OrderBy(p => EF.Property<object>(p, sortedBy));
}Error Message:
"The 'TrigramsAreSimilar' method is not supported because the query has switched to client-evaluation. This usually happens when the arguments to the method cannot be translated to server. Rewrite the query to avoid client evaluation of arguments so that method can be translated to server."
