Starting from Team Foundation Server 2017, the Code Search feature that was available for a while in VSTS, gets an on-premise equivalent.
The feature is built on top of a customized version of ElasticSearch. However the integration between the 2 products(TFS and ElasticSearch) is rather limited right now.
Practical C# Design
Learn about object-oriented and functional programming using C# and .NET. Improve your skills while avoiding pitfalls and common mistakes.
Videos in this list are covering C# syntax, coding practices and patterns applied in object-oriented and functional design.
In this post we will see some informations about Web SQL. I know you all are familiar with SQL, If not I strongly recommend you to read some basic informations here . As the name implies, Web SQL has so many similarities with SQL. So if you are good in SQL, you will love Web SQL too. Web SQL is an API which helps the developers to do some database operations in client side, like creating database, open the transaction, creating tables, inserting values to tables, deleting values, reading the data.
My road for the series is as follows,
RESTful Day #1: Enterprise level application architecture with Web APIs using Entity Framework, Generic Repository pattern and Unit of Work.
RESTful Day #2: Inversion of control using dependency injection in Web APIs using Unity Container and Bootstrapper.
RESTful Day #3: Resolve dependency of dependencies using Inversion of Control and dependency injection in Asp.net Web APIs with Unity Container and Managed Extensibility Framework (MEF).
RESTful Day #4: Custom URL Re-Writing/Routing using Attribute Routes in MVC 4 Web APIs.
RESTful Day #5: Basic Authentication and Token based custom Authorization in Web APIs using Action Filters.
RESTful Day #6: Request logging and Exception handing/logging in Web APIs using Action Filters, Exception Filters and nLog.
RESTful Day #7: Unit testing ASP.NET Web APIs controllers using nUnit.
RESTful Day #8: Extending OData support in ASP.NET Web APIs.
using System;
using System.Linq;
using Raven.Client.Document;
using RavenDBSample01.Models;
namespace RavenDBSample01
{
class Program
{
static void Main(string[] args)
{
using (var store = new DocumentStore
{
Url = "http://localhost:8080"
}.Initialize())
{
using (var session = store.OpenSession())
{
var questions = session.Query<Question>().Where(x => x.Title.StartsWith("Raven"));
foreach (var question in questions)
{
Console.WriteLine(question.Title);
}
}
}
}
}
} Available commands: cls, reset, gc, q
Request # 1: GET - 179 ms - <system> - 404 - /docs/Raven/Replication/Destinations
Request # 2: GET - 3,818 ms - <system> - 200 - /indexes/dynamic/Questions?&query=Title%3ARaven*&pageSize=128
Query: Title:Raven*
Time: 3,494 ms
Index: Auto/Questions/ByTitle
Results: 2 returned out of 2 total. var questions = session.Query<Question>().Where(x => x.Title.StartsWith("Raven")).Take(128); var questions = session.Advanced.LuceneQuery<Question>().Where("Title:Raven*").ToList(); var questions = session.Advanced.LuceneQuery<Question>().WhereStartsWith(x => x.Title, "Raven").ToList();
var query = session.Query<User>().Where(x => x.Name.StartsWith("A"));
var ageQuery = query.Where(x => x.Age > 21);
var eyeQuery = query.Where(x => x.EyeColor == "blue"); query - Name:A*
ageQuery - (Name:A*) AND (Age_Range:{Ix21 TO NULL})
eyeQuery - (Name:A*) AND (EyeColor:blue) var luceneQuery = session.Advanced.LuceneQuery<User>().WhereStartsWith(x => x.Name, "A"); var ageLuceneQuery = luceneQuery.WhereGreaterThan(x => x.Age, 21); var eyeLuceneQuery = luceneQuery.WhereEquals(x => x.EyeColor, "blue");
luceneQuery - Name:A*
ageLuceneQuery - Name:A* Age_Range:{Ix21 TO NULL}
eyeLuceneQuery - Name:A* Age_Range:{Ix21 TO NULL} EyeColor:blue session.Advanced.LuceneQuery<User>().UsingDefaultOperator(QueryOperator.And);
using System;
using System.Linq;
using Raven.Client.Document;
using RavenDBSample01.Models;
namespace RavenDBSample01
{
class Program
{
static void Main(string[] args)
{
using (var store = new DocumentStore
{
Url = "http://localhost:8080"
}.Initialize())
{
using (var session = store.OpenSession())
{
int pageNumber = 0;
int resultsPerPage = 2;
var questions = session.Query<Question>()
.Where(x => x.Title.StartsWith("Raven"))
.Skip(pageNumber * resultsPerPage)
.Take(resultsPerPage);
foreach (var question in questions)
{
Console.WriteLine(question.Title);
}
}
}
}
}
} using System;
using System.Linq;
using Raven.Client.Document;
using RavenDBSample01.Models;
using Raven.Client;
namespace RavenDBSample01
{
class Program
{
static void Main(string[] args)
{
using (var store = new DocumentStore
{
Url = "http://localhost:8080"
}.Initialize())
{
using (var session = store.OpenSession())
{
int pageNumber = 0;
int resultsPerPage = 2;
RavenQueryStatistics stats;
var questions = session.Query<Question>()
.Statistics(out stats)
.Where(x => x.Title.StartsWith("Raven"))
.Skip(pageNumber * resultsPerPage)
.Take(resultsPerPage);
foreach (var question in questions)
{
Console.WriteLine(question.Title);
}
Console.WriteLine("TotalResults: {0}", stats.TotalResults);
}
}
}
}
} var list = session.Query<Question>().Where(q => q.By.In<string>(arrayOfUsers))).ToArray()
SELECT * FROM tbl WHERE data IN (1, 2, 3)
Roslyn syntax tree viewer for C#. Works on JetBrains Rider and all other IntelliJ IDEA-based IDEs.
