[Fixed]How to overcome the linq contains limitation.Too many parameters were provided in this RPC request. the maximum is 2100

When we want to filter the data from the Linq to Sql query with the collection every one is trying to use the Contains() operator as follows. Linq to Sql will try to generate a sql query to represent the whole expression. This means that it will try to pass in the collection as parameters to a sql query. If there are too many parameters the query will hit the parameter limit (2100) and it cannot be executed. If there are not that many parameters, then you can use a contains expression which will be converted to an "IN" expression in sql. Sample code as follows

List<int> contactIds=Contact.GetContactIds()
//count of contactIds is morethan 2100
var contacts = Context.Contacts.Where(c => contactIds.Contains(c.ContactId)).ToList();

If the parameter limit exeeds then the following exception throws.

The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Too many parameters were provided in this RPC request. The maximum is 2100.

To avoid this many developers will try to join the in memory collection with database table as follows. 

List<int> contactIds=Contact.GetContactIds()
//count of contactIds is morethan 2100
var contacts = Context.Contacts.Join(contactIds, c => c.ContactId, ci => ci, (c, ci) => c).ToList();

When developer trying this the following exception throws.

Local sequence cannot be used in LINQ to SQL implementations of query operators except the Contains operator.

This means that the linq to sql generates sql query and executes on the database server. Our in memory collection will not support to execute on the database server. so will get the above exception.
The easiest resolution is to convert the LINQ to SQL table into an IEnumerable list, which can be done as follows.

List<int> contactIds=Contact.GetContactIds()
//count of contactIds is morethan 2100
var contacts = Context.Contacts.AsEnumerable().Join(contactIds, c => c.ContactId, ci => ci, (c, ci) => c).ToList();

I hope this solution helps you.

How to render partial view on each telerik Panel bar

The solution to render the partilal view on telerik panel bar or each panel bar contains one from is as follows. Here partial view contains form.

  @(
     Html.Telerik().PanelBar().Name("PanelBar").HtmlAttributes(new { style = "width: 300px;" }).BindTo(Model, mappings =>
      {
       mappings.For(binding => binding.ItemDataBound((item, manager) =>
       { 
         item.Text = manager.Name;
          item.Html = Html.Partial("Manager_Partial",manager).ToHtmlString();
          }));
         })
   )

How to read the conig file of class library in C Sharp

Every body knows that we can define the appsettings in the app.config file of class library. When we are refering the existing class library to the other new class library that only takes dll but not the configuration file of existing class library. To read values from the configuration file one option is to define same appsettings in the new class library. the other solution is as follows.

Solution:

1. Refer the class library to the other new class library.
2. Copy the .dll.config file from bin/debug folder of the existing class library and add to the new class library.
3. Use the following code to get the values from the .dll.config file.

/// Load the .config file for the current DLL
System.Reflection.Assembly assembly = System.Reflection.Assembly.GetExecutingAssembly();

Configuration dllConfig = ConfigurationManager.OpenExeConfiguration(assembly.Location);

KeyValueConfigurationCollection settings = dllConfig.AppSettings.Settings;

//read the value as follows
string value=settings[key].value;

Handling string null or empty in Deserialization c sharp

When we are deserializing the string to object which we are passing the parameter with dynamic values, we don't know the parameter is null or empty. If we do not handle null or empty then it will throws an exception. But if the method is generic type then we don't know which type of class it is to create an instance and return. To create an instance without new keyword and the type of class use the solution below.

public static T DeSerializeDataContract<T>(String obj)
        {
            if (string.IsNullOrEmpty(obj))
            {
                Type type = typeof(T);
                return (T)Activator.CreateInstance(type);
            }
            using (var stringReader = new StringReader(obj))
            using (var reader = new XmlTextReader(stringReader))
            {
                DataContractSerializer serializer = new DataContractSerializer(typeof(T));
                return (T)serializer.ReadObject(reader);
            }

        }

JQuery multiselect selectedText does not work with JQuery > 1.4.2 when select list contains only one element

This is the problem with the change in the jquery version. Previous jquery(up to 1.4.2) the checkbox checked can be found by using "[checked]". Later versions of jquery changed to ":checked". To fix this issue go the jquery multiselect plugin js file line number 206 and change  $checked = $inputs.filter('[checked]') to $checked = $inputs.filter(':checked'). This solution works for me.

How to get the current controller and action names in View Mvc3

In MVC we can use the partial views to avoid the redundant code. I have one requirement that the action names are same in two different controllers and there is partial view which has one link which needs to point to the current controller with the same action. I want to access the controller name in View to avoid the redundant code. The solution to get the Controller and Action names in View as follows. Solution:

 @{
        var controller = this.ViewContext.Controller.ValueProvider.GetValue("controller").RawValue.ToString();
    
        Change password
        }

If you want to access the action name

var action=this.ViewContext.Controller.ValueProvider.GetValue("action").RawValue.ToString();

Jquery Ajax Request and Unauthorized Access handling in MVC3

When we are posting the data through jquery $.ajax and  we are using asp.net forms authentication, if the user is not authorized then we will redirect to the login page. the same login page response is return result as on jquery ajax success. If we throw any exception in controller or any custom authorize attribute then ajax request returns the 500 status code internal server exception as its default behaviour. 500 status code reruns any exception in the request processing. But our view is to return the 401 as the status code. I research about many hours to get this solution.

Solution1:

1. Custom authentication attribute

public class AdminAuthorizeAttribute : AuthorizeAttribute  
{   
 protected override bool AuthorizeCore(HttpContextBase httpContext)
 {    
  User currentUser = ClientContext.Current.User;    

  return currentUser != null;      

 }

}

If the user is not authenticated the reruns to logon action as i am using forms authentication in asp.net.
2. In the controller action result write the following

 public ActionResult Logon()
 {
  if (Request.IsAjaxRequest())
  {
 
  //this is used when the authentication fails in the ajax request
  //this returns the httpstatus code 401 to the browser.
 
   ControllerContext.HttpContext.Response.StatusCode = 401;
 
   return Content(string.Empty);
  
   }

 } 

3. Handle the status codes in jquery $.ajaxSetup

$.ajaxSetup({
             statusCode: {
                        401: function () {
 
                            // Redirect the to the login page.
                            window.location = "/login/";
 
                        }
                    }
            });

Solution2:

public class AdminAuthorizeAttribute : AuthorizeAttribute  
{   
 protected override bool AuthorizeCore(HttpContextBase httpContext)
 {    
  User currentUser = ClientContext.Current.User;    

  return currentUser != null;      

 }


public override void OnAuthorization(AuthorizationContext filterContext)
{
   base.OnAuthorization(filterContext);

  // If its an unauthorized/timed out ajax request go to top window and redirect to logon.
    if (filterContext.Result is HttpUnauthorizedResult && filterContext.HttpContext.Request.IsAjaxRequest())
    {

filterContext.Result = new JavaScriptResult() { Script = "top.location.reload()"    };
    }

  // If authorization results in HttpUnauthorizedResult, redirect to error page instead of Logon page.
            if (filterContext.Result is HttpUnauthorizedResult)
            {
                if (ClientContext.Current.User == null)
                {
                    filterContext.Result =
                        new RedirectResult(
                            string.Format(
                                "~/logon/logon?ReturnUrl={0}",
                                HttpUtility.HtmlEncode(filterContext.HttpContext.Request.RawUrl)));
                }
                else
                {
                    filterContext.Result =
                       new RedirectResult(string.Format("~/error/unauthorized"));
                }
            }
        }
}

I hope this will help you.