SQL Server FileTable Data Source Extension


This Data Source Extension allows Lightswitch applications to connect with SQL Server FileTables as an external data source; works with both HTML and Silverlight client applications.

(0) Review
Visual Studio
Download (966)
E-mail Twitter del.icio.us Digg Facebook
Add to favorites
Q and A (1)
Sign in to write a review

Be the first to write a review.

Sign in to start a discussion

  • Does anyone want FileType to always be uppercase?
    1 Posts | Last post October 03, 2014
    • Presuming someone other than me uses this extension, here's a question:
      I wanted to filter on FileType in a query against the FileTable the other day, and found that LightSwitch doesn't (easily) deal with case-insensitive queries.  To be fair, the problem isn't LightSwitch, but the collation of the database (which is usually case sensitive) and Entity Framework, but, either way - you can't just issue a switch in your SQL syntax to get back a case-insensitive result.
      I could set this up to where the FileType is always returned in upper case by changing one line of code (e.g., return the FileType.ToUpperInvariant()). You'd still be able to get the original (as cased for the file itself) file type by extracting it from the file name.  This way, if filtering by file type (and there are surely lots of reasons to do that), you don't have to deal with case permutations - the extension will return only the file type(s) you wanted without extra filtering.
      Alternate solution would be to add a property called InvariantFileType that gives you to the FileType.ToUpperInvariant() instead of whatever the original case was. 
      Thoughts / opinions?