C# - NHibernate Unable To Convert MySQL Date / Time Value To System?
Jan 7, 2011
I am getting the "Unable to convert MySQL date/time value to System.DateTime" error because from what I can tell I have a record with 0000-00-00 00:00:00. Now while the data should never be that (it should be null) there are cases when this might happen and I don't want my entire application to crash because of it. I am using NHibernate and I tried adding change my connection string to allow zero datetime so the connection string configuration looks like:
<property name="connection.connection_string">
Server=localhost;Database=user_system;User ID=root;Password=root;
Allow Zero Datetime=true;
</property>
However I still receive that error. How can I allow NHibernate to allow zero values for timestamp/datetime/data/time?
I have two dates. Date1 and Date2 Date1 contains "10/12/2010 12:00:00AM". Date2 contains "10/10/2010 03:00:00PM" I want to extract only the date from Date1 and extract only the time from Date2 and join them. Example "10/12/2010 03:00:00PM".
I have time, for e.g 33 hr 40 mins 50 secs . i would like to convert it to a date time format.
for e.g I have used Convert.ToDateTime("33:40:50"), but in this case when you converting to date time, hour should be less than 24, otherwise it will fire an exception.
I need to convert time to "UTC+03:30 Time Zone" in my web application here is UTC date : DateTime dt = DateTime.UtcNow; Is there any function to convert UTC to my time zone or not ? I don't want to involve myself writing a new function in my application if there is a function in ASP.NET. The application might be hosted in different server in the world and that's exactly why I have used UTC date. I need a function to add 3:30 to the current UTC time.
I have an event in 20 days - on my site I want to put a label withthe text - " there are now (daysleft) to the big day"Every day I want the int in the (daysleft) to count down like 20, 19, 18, 17 etc.is there a simple way to do this using a loop or something??
I am using Calendar to display Date in Textbox. my Problem is that it works Ok in localhost but when I had uploaded the same, error come "Unable to convert String to datetime".
I am writing unit tests for fluent Nhibernate, when I run the test in isloation it passes, but when I run multiple tests. or run the test more than once it starts failing with the message below System.ApplicationException : For property 'Id' expected '1' of type 'System.Int32' but got '2' of type 'System.Int32'
i used below code for date time picker validation but it's not working.
Actually I want a date time picker which date dd/mm/yyyy format date. With validation for start and end date. Also for manual entry it should take only no. and for date rest like / or, will be auto formatted.means user should not be able to enter it.
I'm using Nhibernate as the OR/M tool for an asp.net application and the startup performance is really frustrating. Part of the problem is definitely me in my lack of understanding but I've tried a fair bit (understanding is definitely improving) and am still getting nowhere.
Currently ANTS profiler has that the Configure() takes 13-18 seconds and the BuildSessionFActory() as taking about 5 seconds. From what i've read, these times might actually be pretty good, but they were generally talking about hundreds upon hundreds of mapped entities...this project only has 10.
I've combined all the mapping files into a single hbm mapping file and this did improve things but only down to the times mentioned above...
I guess, are there any "Traps for young players" that are regularly missed...obvious "I did this/have you enabled that/exclude file x/mark file y as z" etc...
I'll try the serialize the configuration thing to avoid the Configure() stage, but I feel that part shouldn't be that long for that amount of entities and so would essentially be hiding a current problem...
am trying to implement fluent nhibernate in MVC project...there were no build errors... but when i run the project i get this exception
System.Xml.Schema.XmlSchemaValidationException: The element 'class' in namespace 'urn:nhibernate-mapping-2.2' has incomplete content. List of possible elements expected: 'meta, subselect, cache, synchronize, comment, tuplizer, id, composite-id' in namespace 'urn:nhibernate-mapping-2.2'.
have no idea what am doing wrong here... the following is the code for opening session factory...
I have this method which does not build, it errors with the message:
Cannot implicitly convert type 'System.Web.HttpPostedFile' to 'System.Web.HttpPostedFileBase' I really need this to be of type HttpPostedFileBase instead of HttpPostedFile, I have tried boxing and it does not work: foreach (string inputTagName in HttpContext.Current.Request.Files) { HttpPostedFileBase filebase =HttpContext.Current.Request.Files[inputTagName]; if (filebase.ContentLength > 0) { if (filebase.ContentType.Contains("image/")) { SaveNonAutoExtractedThumbnails(doc, filebase); } } }
i work with visual studio 2005 and asp net 2.0. i have a method method as this :
[Code]....
this problem is follow if i run the web method and don't enter a string and a int a receive this message : System.ArgumentException: Cannot convert to System.Int32. ok when i arrive in the method i can check if lists is empty but how i can do if int is NULL because i don't want to returns a error if people run my web method and don't enter the parameters.
i have installed ajax control kit successfully and all controls already came in toolbar tab named "Ajax Control toolkit"But when i try to design any page using with ajax control toolkit, follow error is coming:
Could not load type 'System.Web.UI.ScriptReferenceBase' from assembly 'System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.TypeLoadException: Could not load type 'System.Web.UI.ScriptReferenceBase' from assembly 'System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'.
Source Error:[Code]....
Stack Trace: [Code]....
[TypeLoadException: Could not load type 'System.Web.UI.ScriptReferenceBase' from assembly 'System.Web.Extensions, Version=3.5.0.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35'.] AjaxControlToolkit.ToolkitScriptManager.OnResolveScriptReference(ScriptReferenceEventArgs e) in [code]...
I am using VIsual Studio 2008 , framework 3.5 but i don't know why in error information version is showing 2.0
i install tool kit according 3.5 framework.also note, framework built-in ajax tags i can use fine and they work properly.
