{“LINQ to Entities does not recognize the method ‘System.String PadLeft(Int32,Char)’ method,and this method cannot be translated into a store expression.”}
您需要使用连接字符串DbProviderFactory和MysqL Connector 6.5.4的自定义DatabaseInitializer设置您的配置。我详细说明了
full step for getting EF5 and MySql to play,including code for the initializers on my blog.如果您需要ASP.Net会员提供程序解决方案,那么我将在
ASP.NET Membership/Role providers for MySQL?发布解决方案,同时提供完整的EF5 MysqL解决方案。
在我之前的文章:ASP.NET MVC2.0 结合 WF4.0 实现用户多步注册流程中将一个用户的注册分成了四步,而这四个步骤都是在完善一个 Model 的信息,但是又分页面填写信息的,当时我加上 ModelState.IsValid 这句验证代码的时候,根本没法通过验证,因为在注册的前面三步,注册用户的 Model 信息都没填写完整,而 ModelState.IsValid 是对一个实体的所有属性进行判断验证的。当时很纠结,因为刚接触 Asp.net MVC,故没有找到解决方案。这篇文章将给出解决的办法。看下面需要验证的 Model 的代码如下:
public IEnumerable<SelectListItem> StepList { get; set; }
public UserViewModel() { var list =new List<SelectListItem>() { new SelectListItem { Text ="(Select)" }, new SelectListItem { Value ="1", Text ="Step1" }, new SelectListItem { Value ="2", Text ="Step2" }, new SelectListItem { Value ="3", Text ="Step3" }, new SelectListItem { Value ="4", Text ="Step4" } }; this.StepList =new SelectList(list, "Value", "Text"); }
///<summary>Used to denote the encoding necessary for files containing JavaScript source code. The alternative MIME type for this file type is text/javascript.</summary>
public const string ApplicationXJavascript = "application/x-javascript";
///<summary>24bitLinear PCMaudio at 8-48kHz,1-N channels; Defined inRFC 3190</summary>
public const string AudioL24 = "audio/L24";
///<summary>Adobe Flashfiles for example with the extension .swf</summary>
public const string ApplicationXShockwaveFlash = "application/x-shockwave-flash";
///<summary>Arbitrary binary data.[5]Generally speaking this type identifies files that are not associated with a specific application. Contrary to past assumptions by software packages such asApachethis is not a type that should be applied to unkNown files. In such a case,a server or application should not indicate a content type,as it may be incorrect,but rather,should omit the type in order to allow the recipient to guess the type.[6]</summary>
public const string ApplicationOctetStream = "application/octet-stream";
///<summary>Atom Feeds</summary>
public const string ApplicationAtomXml = "application/atom+xml";
///<summary>Cascading Style Sheets; Defined inRFC 2318</summary>
public const string TextCss = "text/css";
///<summary>commands; subtype resident inGeckobrowsers likeFirefox3.5</summary>
public const string TextCmd = "text/cmd";
///<summary>Comma-separated values; Defined inRFC 4180</summary>
public const string TextCsv = "text/csv";
///<summary>deb (file format),a software package format used by the Debian project</summary>
public const string ApplicationXDeb = "application/x-deb";
///<summary>Defined inRFC 1847</summary>
public const string MultipartEncrypted = "multipart/encrypted";
///<summary>Defined inRFC 1847</summary>
public const string MultipartSigned = "multipart/signed";
///<summary>Defined inRFC 2616</summary>
public const string MessageHttp = "message/http";
///<summary>Defined inRFC 4735</summary>
public const string ModelExample = "model/example";
///<summary>device-independent document in DVI format</summary>
public const string ApplicationXDvi = "application/x-dvi";
///<summary>DTDfiles; Defined byRFC 3023</summary>
public const string ApplicationXmlDtd = "application/xml-dtd";
///<summary>ECMAScript/JavaScript; Defined inRFC 4329(equivalent toapplication/ecmascriptbut with looser processing rules) It is not accepted inIE 8or earlier -text/javascriptis accepted but it is defined as obsolete inRFC 4329. The "type" attribute of the<script>tag inHTML5is optional and in practice omitting the media type of JavaScript programs is the most interoperable solution since all browsers have always assumed the correct default even before HTML5.</summary>
public const string ApplicationJavascript = "application/javascript";
///<summary>ECMAScript/JavaScript; Defined inRFC 4329(equivalent toapplication/javascriptbut with stricter processing rules)</summary>
public const string ApplicationEcmascript = "application/ecmascript";
///<summary>EDIEDIFACTdata; Defined inRFC 1767</summary>
public const string ApplicationEdifact = "application/EDIFACT";
///<summary>EDIX12data; Defined inRFC 1767</summary>
public const string ApplicationEdiX12 = "application/EDI-X12";
///<summary>Email; Defined inRFC 2045andRFC 2046</summary>
public const string MessagePartial = "message/partial";
///<summary>Email;EMLfiles,MIME files,MHTfiles,MHTMLfiles; Defined inRFC 2045andRFC 2046</summary>
public const string MessageRfc822 = "message/rfc822";
///<summary>Extensible MarkuP Language; Defined inRFC 3023</summary>
public const string textxml = "text/xml";
///<summary>Extensible MarkuP Language; Defined in RFC 3023</summary>
public const string ApplicationXml = "application/xml";
///<summary>Flash video(FLV files)</summary>
public const string VideoXFlv = "video/x-flv";
///<summary>GIFimage; Defined inRFC 2045andRFC 2046</summary>
public const string ImageGif = "image/gif";
///<summary>GoogleWebToolkit data</summary>
public const string textxGwtRpc = "text/x-gwt-rpc";
///<summary>Gzip</summary>
public const string ApplicationXGzip = "application/x-gzip";
///<summary>HTML; Defined inRFC 2854</summary>
public const string TextHtml = "text/html";
///<summary>ICOimage; Registered[9]</summary>
public const string ImageVndMicrosoftIcon = "image/vnd.microsoft.icon";
///<summary>IGS files,IGESfiles; Defined inRFC 2077</summary>
public const string ModelIges = "model/iges";
///<summary>IMDNInstant Message disposition Notification; Defined inRFC 5438</summary>
public const string MessageImdnXml = "message/imdn+xml";
///<summary>JavaScript Object NotationjsON; Defined inRFC 4627</summary>
public const string Applicationjson = "application/json";
///<summary>JavaScript Object Notation (JSON) Patch; Defined inRFC 6902</summary>
public const string ApplicationjsonPatch = "application/json-patch+json";
///<summary>JavaScript - Defined in and obsoleted byRFC 4329in order to discourage its usage in favor ofapplication/javascript. However,text/javascriptis allowed in HTML 4 and 5 and,unlikeapplication/javascript,has cross-browser support. The "type" attribute of the<script>tag inHTML5is optional and there is no need to use it at all since all browsers have always assumed the correct default (even in HTML 4 where it was required by the specification).</summary>
[Obsolete]
public const string TextJavascript = "text/javascript";
///<summary>JPEGJFIF image; Associated with Internet Explorer; Listed inms775147(v=vs.85)- Progressive JPEG,initiated before global browser support for progressive JPEGs (Microsoft and Firefox).</summary>
public const string ImagePjpeg = "image/pjpeg";
///<summary>JPEGJFIF image; Defined inRFC 2045andRFC 2046</summary>
public const string ImageJpeg = "image/jpeg";
///<summary>jQuerytemplate data</summary>
public const string textxJqueryTmpl = "text/x-jquery-tmpl";
///<summary>KMLfiles (e.g. forGoogle Earth)</summary>
public const string ApplicationVndGoogleEarthKmlXml = "application/vnd.google-earth.kml+xml";
///<summary>LaTeXfiles</summary>
public const string ApplicationXLatex = "application/x-latex";
///<summary>Matroskaopen media format</summary>
public const string VideoXMatroska = "video/x-matroska";
///<summary>Microsoft Excel2007 files</summary>
public const string ApplicationVndOpenxmlformatsOfficedocumentSpreadsheetmlSheet = "application/vnd.openxmlformats-officedocument.spreadsheetml.sheet";
///<summary>Microsoft Excelfiles</summary>
public const string ApplicationVndMsExcel = "application/vnd.ms-excel";
///<summary>Microsoft Powerpoint2007 files</summary>
public const string ApplicationVndOpenxmlformatsOfficedocumentPresentationmlPresentation = "application/vnd.openxmlformats-officedocument.presentationml.presentation";
///<summary>Microsoft Powerpointfiles</summary>
public const string ApplicationVndMsPowerpoint = "application/vnd.ms-powerpoint";
///<summary>Microsoft Word2007 files</summary>
public const string ApplicationVndOpenxmlformatsOfficedocumentWordprocessingmlDocument = "application/vnd.openxmlformats-officedocument.wordprocessingml.document";
///<summary>Microsoft Wordfiles[15]</summary>
public const string ApplicationMsword = "application/msword";
///<summary>MIMEEmail; Defined inRFC 2045andRFC 2046</summary>
public const string MultipartAlternative = "multipart/alternative";
///<summary>MIMEEmail; Defined inRFC 2045andRFC 2046</summary>
public const string MultipartMixed = "multipart/mixed";
///<summary>MIMEEmail; Defined inRFC 2387and used byMHTML(HTML mail)</summary>
public const string MultipartRelated = "multipart/related";
///<summary>MIMEWebform; Defined inRFC 2388</summary>
public const string MultipartFormData = "multipart/form-data";
///<summary>MozillaXULfiles</summary>
public const string ApplicationVndMozillaXulXml = "application/vnd.mozilla.xul+xml";
///<summary>MP3or otherMPEGaudio; Defined inRFC 3003</summary>
public const string AudioMpeg = "audio/mpeg";
///<summary>MP4audio</summary>
public const string AudioMp4 = "audio/mp4";
///<summary>MP4video; Defined inRFC 4337</summary>
public const string VideoMp4 = "video/mp4";
///<summary>MPEG-1video with multiplexed audio; Defined inRFC 2045andRFC 2046</summary>
public const string VideoMpeg = "video/mpeg";
///<summary>MSH files,MESH files; Defined inRFC 2077,SILO files</summary>
public const string ModelMesh = "model/mesh";
///<summary>mulawaudio at 8kHz,1 channel; Defined inRFC 2046</summary>
public const string AudioBasic = "audio/basic";
///<summary>OggTheoraor other video (with audio); Defined inRFC 5334</summary>
public const string VideoOgg = "video/ogg";
///<summary>OggVorbis,Speex,Flacand other audio; Defined inRFC 5334</summary>
public const string AudioOgg = "audio/ogg";
///<summary>Ogg,a multimedia bitstreamcontainer format; Defined inRFC 5334</summary>
public const string ApplicationOgg = "application/ogg";
///<summary>OP</summary>
public const string ApplicationXopXml = "application/xop+xml";
///<summary>opendocumentGraphics; Registered[14]</summary>
public const string ApplicationVndoasisopendocumentGraphics = "application/vnd.oasis.opendocument.graphics";
///<summary>opendocumentPresentation; Registered[13]</summary>
public const string ApplicationVndoasisopendocumentPresentation = "application/vnd.oasis.opendocument.presentation";
///<summary>opendocumentSpreadsheet; Registered[12]</summary>
public const string ApplicationVndoasisopendocumentSpreadsheet = "application/vnd.oasis.opendocument.spreadsheet";
///<summary>opendocumentText; Registered[11]</summary>
public const string ApplicationVndoasisopendocumentText = "application/vnd.oasis.opendocument.text";
///<summary>p12 files</summary>
public const string ApplicationXPkcs12 = "application/x-pkcs12";
///<summary>p7b and spc files</summary>
public const string ApplicationXPkcs7Certificates = "application/x-pkcs7-certificates";
///<summary>p7c files</summary>
public const string ApplicationXPkcs7Mime = "application/x-pkcs7-mime";
///<summary>p7r files</summary>
public const string ApplicationXPkcs7certreqresp = "application/x-pkcs7-certreqresp";
///<summary>p7s files</summary>
public const string ApplicationXPkcs7Signature = "application/x-pkcs7-signature";
///<summary>Portable Document Format,PDFhas been in use for document exchange on the Internet since 1993; Defined inRFC 3778</summary>
public const string ApplicationPdf = "application/pdf";
///<summary>Portable Network Graphics; Registered,[8]Defined inRFC 2083</summary>
public const string ImagePng = "image/png";
///<summary>PostScript; Defined inRFC 2046</summary>
public const string ApplicationPostscript = "application/postscript";
///<summary>QuickTimevideo; Registered[10]</summary>
public const string VideoQuicktime = "video/quicktime";
///<summary>Rararchive files</summary>
public const string ApplicationXRarCompressed = "application/x-rar-compressed";
///<summary>RealAudio; Documented inRealPlayer Customer Support Answer 2559</summary>
public const string AudioVndRnRealaudio = "audio/vnd.rn-realaudio";
///<summary>Resource Description Framework; Defined byRFC 3870</summary>
public const string ApplicationRdfXml = "application/rdf+xml";
///<summary>RSS Feeds</summary>
public const string ApplicationRSSXml = "application/RSS+xml";
///<summary>SOAP; Defined byRFC 3902</summary>
public const string ApplicationSoapXml = "application/soap+xml";
///<summary>StuffItarchive files</summary>
public const string ApplicationXStuffit = "application/x-stuffit";
///<summary>SVGvector image; Defined inSVG Tiny 1.2 Specification Appendix M</summary>
public const string ImageSvgXml = "image/svg+xml";
///<summary>Tag Image File Format(only for Baseline TIFF); Defined inRFC 3302</summary>
public const string ImageTiff = "image/tiff";
///<summary>Tarballfiles</summary>
public const string ApplicationXTar = "application/x-tar";
///<summary>Textual data; Defined inRFC 2046andRFC 3676</summary>
public const string TextPlain = "text/plain";
///<summary>TrueType FontNo registered MIME type,but this is the most commonly used</summary>
public const string ApplicationXFontTtf = "application/x-font-ttf";
///<summary>vCard(contact information); Defined inRFC 6350</summary>
public const string TextVcard = "text/vcard";
///<summary>Vorbisencoded audio; Defined inRFC 5215</summary>
public const string AudioVorbis = "audio/vorbis";
///<summary>WAVaudio; Defined inRFC 2361</summary>
public const string AudioVndWave = "audio/vnd.wave";
///<summary>Web Open Font Format; (candidate recommendation; useapplication/x-font-woffuntil standard is official)</summary>
public const string ApplicationFontWoff = "application/font-woff";
///<summary>WebMMatroska-based open media format</summary>
public const string VideoWebm = "video/webm";
///<summary>WebMopen media format</summary>
public const string AudioWebm = "audio/webm";
///<summary>Windows Media AudioRedirector; Documented inMicrosoft help page</summary>
public const string AudioxmsWax = "audio/x-ms-wax";
///<summary>Windows Media Audio; Documented inMicrosoft KB 288102</summary>
public const string AudioxmsWma = "audio/x-ms-wma";
///<summary>Windows Media Video; Documented inMicrosoft KB 288102</summary>
public const string VideoxmsWmv = "video/x-ms-wmv";
///<summary>WRLfiles,Vrmlfiles; Defined inRFC 2077</summary>
public const string ModelVrml = "model/vrml";
///<summary>X3disOstandard for representing3D computer graphics,X3DXMLfiles</summary>
public const string ModelX3DXml = "model/x3d+xml";
///<summary>X3disOstandard for representing3D computer graphics,X3DBbinaryfiles</summary>
public const string ModelX3DBinary = "model/x3d+binary";
///<summary>X3disOstandard for representing3D computer graphics,X3DVVrmlfiles</summary>
public const string ModelX3DVrml = "model/x3d+vrml";
///<summary>XHTML; Defined byRFC 3236</summary>
public const string ApplicationXhtmlXml = "application/xhtml+xml";
///<summary>ZIParchive files; Registered[7]</summary>
public const string ApplicationZip = "application/zip";
今天关于asp.net-mvc-4 – EF5.x中对PadLeft缺乏支持的任何解决方法?的分享就到这里,希望大家有所收获,若想了解更多关于ASP.NET MVC 4 EF5与MySQL、ASP.NET MVC 中对 Model 进行分步验证的解决方法、asp.net – 在.NET中以编程方式添加HttpHandler的任何方法?、asp.net-mvc – ASP MVC – 有默认内容类型的任何常量?等相关知识,可以在本站进行查询。