Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT
- [titles].[title],
- [assets].[filename]
- FROM
- titles
- INNER JOIN
- assets ON titles.ID = assets.ID
- WHERE
- (title LIKE '%Life-Span%'
- AND title LIKE '%Development%'
- AND title LIKE '%16E%'
- AND title LIKE '%99%'
- AND title LIKE '%Subject%'
- AND title LIKE '%Index%')
- static void Main(string[] args)
- {
- string searchText = "Life-Span Development 16E 99 Subject Index";
- using (Entities db = new Entities())
- {
- var result = db.titles
- .Join(db.assets,
- p => p.tid,
- e => e.tid,
- (p, e) => new {
- title = p.title1,
- fileName = e.filename
- });
- var searchTextArray = searchText.ToLower().Split(' ');
- result = result.Where(t => searchTextArray.Any(s => t.title.ToLower().Contains(s)));
- foreach(var item in result)
- {
- Console.WriteLine(string.Format("Title = {0} and finename = {1}", item.title, item.fileName));
- }
- }
- Console.ReadKey();
- }
- namespace Like
- {
- class Program
- {
- static bool Is(char a, char b)
- {
- return a == b ||
- char.ToUpper(a) == b ||
- char.ToUpper(b) == a;
- }
- static bool IsLike(string sample, string query)
- {
- int k = 0;
- foreach (char c in sample)
- {
- if (!Is(c, query[k]))
- {
- k = 0;
- continue;
- }
- if (++k == query.Length)
- return true;
- }
- return false;
- }
- static void Main(string[] args)
- {
- string testSample = "This is a str1ng 0f charac7er5";
- Console.WriteLine(IsLike(testSample, "this"));
- Console.WriteLine(IsLike(testSample, "of"));
- Console.WriteLine(IsLike(testSample, "chAra"));
- Console.ReadKey();
- }
- }
- }
Add Comment
Please, Sign In to add comment