LINQ prioritize order

I recently faced a scenario of prioritizing search results filtered by LINQ. Here is the scenario:

I have these records in database table:

1. Superman vs Batman
2. Batman
3. Dark night rises - Batman
4. Batman Returns

I want to search all the records having 'batman' text, however the words starting with batman should be displayed first. i.e. the order should be:

1. Batman
2. Batman Returns
...


This can be achieved using this simple LINQ query:

DbContext.Movies.Where(w => w.Name.Contains("batman")).OrderBy(d => d.Name.IndexOf("batman")).ToList();

I've highlighted the key part of the query which sorts the results based on the Index of word "batman". This means, if the word starts with 'batman', the index would be 0 and it would be displayed first.

Executing MySQL sub routine in Entity Framework

Entity framework has an easy and slick way to support MySql. In MySQL stored procedures are called stored routines. Routines can be called from Entity Framework using below syntax:


using (var dbContext = new DatabaseContext())
{
  var subRoutine = string.Format("CALL StoredRoutineName('{0}','{1}')", value1, value2);
   signInAttempts = dbContext.Database.SqlQuery<int>(subRoutine,
                     new MySqlParameter("value1", value1),
                     new MySqlParameter("value2", value2)).FirstOrDefault();

}

Invalid object name 'dbo.__MigrationHistory'

Recently I faced an issue with Entity Framework 6.0. The error did not crashed the website, but I got it frequently in event viewer. To resolve this, I just added a line in DbContext's constructor:

public DatabaseContext() : base("name=Sample")
{
       Database.SetInitializer<DatabaseContext>(null);
}


If you use an existing database with Code First approach, you may not want to execute any initialization code. You can disable the database initialization process altogether by passing null to SetInitializer() method

C# CSV to Datatable

Add reference of  Microsoft.VisualBasic which would enable TextFieldParser class

using Microsoft.VisualBasic.FileIO;

public static DataTable GetDataTabletFromCsvFile(string csvFilePath)
{
    DataTable csvData = new DataTable();
    using (TextFieldParser csvReader = new TextFieldParser(csvFilePath,Encoding.UTF7))
    {
        csvReader.SetDelimiters(new string[] { "," });
        csvReader.HasFieldsEnclosedInQuotes = true;
        //read column names
        string[] colFields = csvReader.ReadFields();
        foreach (string column in colFields)
        {
            DataColumn datecolumn = new DataColumn(column);
            datecolumn.AllowDBNull = true;
            csvData.Columns.Add(datecolumn);
        }
        while (!csvReader.EndOfData)
        {
            string[] fieldData = csvReader.ReadFields();
            //Making empty value as null
            for (int i = 0; i < fieldData.Length; i++)
            {
                if (fieldData[i] == "")
                {
                    fieldData[i] = null;
                }
            }
            csvData.Rows.Add(fieldData);
        }
    }
    return csvData;
}

ASP.NET MVC partial view to string

protected string RenderPartialViewToString(string viewName, object model)
{
   if (string.IsNullOrEmpty(viewName))
                viewName = ControllerContext.RouteData.GetRequiredString("action");

    ViewData.Model = model;

   using (StringWriter sw = new StringWriter())
  {
     ViewEngineResult viewResult = 

           ViewEngines.Engines.FindPartialView(ControllerContext, viewName);
     ViewContext viewContext = 

          new ViewContext(ControllerContext, viewResult.View, ViewData, TempData, sw);
      viewResult.View.Render(viewContext, sw);

      return sw.GetStringBuilder().ToString();
  }
}

Get query string in javascript from URL

function getUrlParameterByName(name) {

     
        name = name.replace(/[\[]/, "\\\[").replace(/[\]]/, "\\\]");
        var regex = new RegExp("[\\?&]" + name + "=([^&#]*)"),
        results = regex.exec(location.search);
        return results === null ? "" : decodeURIComponent(results[1].replace(/\+/g, " "));
     
}

URL: http://www.nishitvaghela.blogspot.com?page=2&size=10

getUrlParameterByName('page') = 2

The EXECUTE permission was denied on the object 'sp_OACreate'

use [master]
GO

GRANT EXECUTE ON [sys].[sp_OASetProperty] TO [public]
GO

use [master]
GO

GRANT EXECUTE ON [sys].[sp_OAMethod] TO [public]
GO

use [master]
GO

GRANT EXECUTE ON [sys].[sp_OAGetErrorInfo] TO [public]
GO

use [master]
GO

GRANT EXECUTE ON [sys].[sp_OADestroy] TO [public]
GO

use [master]
GO

GRANT EXECUTE ON [sys].[sp_OAStop] TO [public]
GO

use [master]
GO

GRANT EXECUTE ON [sys].[sp_OACreate] TO [public]
GO

use [master]
GO

GRANT EXECUTE ON [sys].[sp_OAGetProperty] TO [public]
GO

sp_configure 'show advanced options', 1
GO

reconfigure
go

exec sp_configure
go

exec sp_configure 'Ole Automation Procedures', 1
go

reconfigure