1:
2:
3:
4:
5:
6:
7:
8:
9:
10:
11:
12:
13:
14:
15:
16:
17:
18:
19:
20:
21:
22:
23:
24:
25:
26:

    public class MdbConnectionMySql : MdbConnection
    {

        public MdbConnectionMySql(string ServerName, string DatabaseName, string UserName, string Password) 
            : base(ServerName, DatabaseName, UserName, Password)
        {
            providerName = "MySql.Data.MySqlClient";
            entityConn = new EntityConnection(this.GetEntityConnectionString());
        }

        public override string GetEntityConnectionString()
        {
            MySqlConnectionStringBuilder strBuilder = new MySqlConnectionStringBuilder();
            strBuilder.Database = DatabaseName;
            strBuilder.Server = ServerName;
            strBuilder.UserID = UserName;
            strBuilder.Password = Password;

            EntityConnectionStringBuilder entityBuilder = new EntityConnectionStringBuilder();
            entityBuilder.Provider = providerName;
            entityBuilder.ProviderConnectionString = strBuilder.ToString();
            entityBuilder.Metadata = @"res://*/MdbModelSystemApplication.csdl|res://*/MdbModelSystemApplication.ssdl|res://*/MdbModelSystemApplication.msl";

            return entityBuilder.ToString();
        }
    }                    

1:

System.InvalidOperationException: The property 'cryptPassword' is part of the object's key information and cannot be modified.                    

1:
2:

Error  1  Error 3003: Problem in Mapping Fragment starting at line 252: All the key properties (MdbUserSet.authorizedUserId, MdbUserSet.created, MdbUserSet.createdBy, MdbUserSet.eMail, MdbUserSet.fullName, MdbUserSet.isDeleted, MdbUserSet.isSystem, MdbUserSet.loginName, MdbUserSet.modified, MdbUserSet.modifiedBy, MdbUserSet.passwordSalt, MdbUserSet.userId) of the EntitySet MdbUserSet must be mapped to all the key properties (v_system_user_select.authorizedUserId, v_system_user_select.created, v_system_user_select.createdBy, v_system_user_select.cryptPassword, v_system_user_select.eMail, v_system_user_select.fullName, v_system_user_select.isDeleted, v_system_user_select.isSystem, v_system_user_select.loginName, v_system_user_select.modified, v_system_user_select.modifiedBy, v_system_user_select.passwordSalt, v_system_user_select.userId) of table v_system_user_select.
  C:\usbstick\daveworldSVN\tooma\2009-07-15\Provider.Mdb\MdbModelSystemApplication.edmx  253  15  Provider.Mdb                    

1:
2:
3:
4:
5:
6:
7:
8:
9:
10:

            var usrQuery = from u in entities.MdbUserSet where u.loginName.Contains(loginname) && u.isSystem == 0 && u.isDeleted == 0 && u.isApproved == 1 select new { u };
            List<MdbUser> userList = new List<MdbUser>();

            foreach (var q in usrQuery)
            {
                q.u.cryptPassword = null;
                q.u.passwordSalt = null;
                userList.Add(q.u);
            }
            return userList.ToArray();