CSS not loading in delployment in server

This is very common issue that when we deploy mvc4 application to server and found that css not loaded and style sheet link looks like

<link href="/Content/themes/base/css?v=myqT7npwmF2ABsuSaHqt8SCvK8UFWpRv7T4M8r3kiK01" rel="stylesheet"/>

solution for this issue is very simple

<compilation debug="false" targetFramework="4.0">

How to remove shared layout in MVC

As we know sometimes views has taken shared layout and we don't want to append that in design as we have another design pattern in some cases.

So we have to disable shared layout as it takes by default.


@{
    Layout = null;
}


Thanks

LINQ to Entities does not recognize the method 'System.Object get_Item(System.String)' method, and this method cannot be translated into a store expression.

The Linq query is ultimately transformed into an SQL query and LINQ doesn't know what to do with Session["UserName"] (that gets the "UserName" item).

A common way to workaround this is just to use a local variable to which you'll assign Session["UserName"] and that you'll use in your Linq query...

like  

string loggedUserName = Session["LogedUsername"].ToString();
  var userdetail =
dc.faculties.Where(a => a.F_UserName.Equals(loggedUserName)).FirstOrDefault();

Unable to load the specified metadata resource

MetadataException: Unable to load the specified metadata resource

This means that the application is unable to load the EDMX.

There are several things which can cause this, but most likely, due to invalid connection string. 


Possible Solutions:

1.Check connection string 
2.Refresh model.edmx
3.Select option "Update Model from database"  in model.edmx

How To Delete table row in sql database by LINQ query?

First of all get the row form id 

This is a method for delete row from summary table.

So here I pass id for which I want to delete the row

This is database context 

private UserContext database = new UserContext("UserConnection");


table name :summeries

   public ActionResult del_summary(int id = 0)
        {
            var summary_delete = database.summeries.Find(id);

            var delete = database.summeries.Remove(summary_delete);

            database.SaveChanges();

            return RedirectToAction("ExceptionListing");

        }


It will delete row from table.

Thanks for visiting.Please comment here if you have any query regarding it.

How To make dynamic query in LINQ in MVC4

Make Dynamic query in Linq

There are two way to make dynamic query in Linq

1. Use Dynamic LINQ libarary
2. Use PredicateBuilder

Use Dynamic LINQ libarary


Step1:You need to install DynamicLINQ library by Package Manager Console

To install DynamicLINQ, run the following command in the Package Manager Console

PM> Install-Package DynamicLINQ

Step 2: Write Query

Case: I want to write the dyanmic query for search form where fields are menitoned below

So here I have made linq query in two way 

1.By variable 
2.By same as sql server


string strWhere = string.Empty;// initialize string strWhere 

 strWhere = strWhere + "TRNDTE >= @0 and TRNDTE<=@1 and PRODVAL >=@2 and PRODVAL<=@3"; // assign some fields value in variable as it will give error in below manner

Error:opernads >= and <= incompatible with linq;

To avoid above error I assign those value in variable and assign to string 


Now rest of code similar to sql server dynamic query and assign to string strWhere 

            if (!string.IsNullOrEmpty(vouchers.CUSTNAME))
            {
                if (!string.IsNullOrEmpty(strWhere))
                    strWhere = strWhere + " and ";
                strWhere = strWhere + "CUSTNAME.StartsWith(\"" + vouchers.CUSTNAME + "\")";
            }

            if (!string.IsNullOrEmpty(vouchers.PANNUM) && vouchers.PANNUM != "0")
            {
                if (!string.IsNullOrEmpty(strWhere))
                    strWhere = strWhere + " and ";
                strWhere = strWhere + "PANNUM == \"" + vouchers.PANNUM + "\"";

            }
            if (!string.IsNullOrEmpty(vouchers.TRNNUM) && vouchers.TRNNUM != "0")
            {
                if (!string.IsNullOrEmpty(strWhere))
                    strWhere = strWhere + " and ";
                strWhere = strWhere + "TRNNUM == \"" + vouchers.TRNNUM + "\"";

            }
           
            if (vouchers.CRDTYPE != 0)
            {
                if (!string.IsNullOrEmpty(strWhere))
                    strWhere = strWhere + " && ";
                strWhere = strWhere + "CRDTYPE == " + vouchers.CRDTYPE;

            }

Finally pass string to lambda representation and replace variable to value pass to function 
            var vouchers_search = database.vouchers.Where(strWhere, TRNDTE_ST, TRNDTE_EN, PRODVAL_MIN, PRODVAL_MAX);

return vouchers_search;

If still you have a query please comment here ,I'll definitly try to help you 

Thanks for visit