Support & Learning
Adaptive User Experience
Data Connectivity and Integration
Web Experience Management
Get A Free Trial
close mobile menu
is Senior Software Architect in OpenAccess ORM Team
String Matching in LINQ
Performing simple string equality tests is often not enough when application user convenience is key. Often only a fragment of a string is known to the user, or many of them. Sometimes there is a need to search for a fragment in multiple columns. Which options does OpenAccess and LINQ provide to perform string matching? Into which SQL is the LINQ expression translated? Let’s use a simple class model for this post: a Person with a FirstName, a LastName and a NickName. Let’s assume parameters with the name simpleParam (string) and manyParam (ICollection<string>). String equality comparison Using the standard Equals method translates directly into...
April 17, 2012
Why OpenAccess does require transactions?
OpenAccess relies on lazy loading and change tracking to make is as easy as possible for the user to work with persistent data. But we need a point in time where we can collect all changes in memory and execute the insert, update and delete statements to persist the changes. Typically this is the job of a transaction. The easiest way is to never let OpenAccess run without a started transaction. In this case you only have to call commit or...
July 14, 2009
Latest updates in your inbox
Introducing the 60fps Grid in Kendo UI for Angular
August 31, 2018
R3 2018 Sneak Peek: What's Next for Telerik UI for ASP.NET AJAX
August 28, 2018
.NET Conf: Ways to Watch, Learn and Win
August 21, 2018