Entity Framework 6 - Knowledge Base (KB)

How to fix "SqlException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value."

SqlException: The conversion of a datetime2 data type to a datetime data type resulted in an out-of-range value....my code is like this:... using (var contxt = new realtydbEntities()) { var status = GetStatus(); var...

Error "Failed to set database initializer of type MyNamespace.MyCustomInitializer, MyAssembly" could not load MyContext type

I'm creating a web app using .NET4.5 with Entity Framework 6 alpha3 that uses a new SQL Compact database. The database does not yet exist....I have the following code in a web form:...public IQueryable<Job> listJobs_GetData() { var db = new Journalist...

Fixing JSON Date serialization from .Net web method

I am currently working on a project where I am sending a .Net type via ajax to a client application via ajax. I have no issues with the object being serialized and set to the client....I run into issues when I take the exactly same object and post it bac...

Build Dynamic Select using Expression Trees

How would I generate the following using expression trees......var people = context.Set<Person>(); var transactions = context.Set<FinancialTransaction>(); var dataview = people.Where( p => p.LastName == "Smith" ); var selection = dataview .Selec...

ASP.Net Identity with WebForms to existing SQL database

I tried the ASP.Net identity and it works fine. I then tried to get it working with an existing SQL database using the pre-created scripts as provided here: ...SQL script for creating an ASP.NET Identity Database...I changed the default connection string ...

Foreign Key Lookup Dropdownlist EF 6

I have been googling for 3 days, and can't find a usable answer, I'm hoping someone can help me....I'm starting with this EXCELLENT tutorial:...http://www.asp.net/web-forms/tutorials/data-access/model-binding/retrieving-data...I'm trying to extend this pr...

quickest way to implement .net authentication in Web Forms with Entity Framework 6

I have been checking resources to implement authentication in my web forms application built with entity framework. All examples I found are MVC-related. I have used regular Asp.Net Membership framework a long time before I began to use EF. However, I cou...

Error: Cannot implicitly convert type 'System.Data.Entity.DbSet' to 'System.Linq.IQueryable'

I am trying to follow the following tutorial: ASP.NET Web Forms Getting started with Web Forms and Visual studio (URL: ...http://www.asp.net/web-forms/overview/getting-started/getting-started-with-aspnet-45-web-forms/introduction-and-overview...)....I hav...

Validate entry length based on database-first entity model

My client is using c#, EF6.0 database-first, and webforms. I want to validate for the max length of a textbox entry in an aspx form. I don't want to hardcode the max-length client-side or server-side, instead I want to retrieve it from the EF6.0 entity mo...

How to Redirect User to Login Page if User Directly Accesses Any Page in ASP.NET WebForms

I am working on ASP.NET webforms. I want to redirect the user to login page if user directly enters the URL of any other page. I have added the below code in web.config file and it redirects the user to login page in case the user tries to access any othe...

Can't Enable a button from JavaScript

<script type="text/javascript"> function Enable_Butt() { document.getElementById("<%=RadButton1.ClientID%>").disabled = false; // Doesn't Work } </script> ...i also tried this an...