Try to decide which of the features you mention -- simplicity, flexibility, POCO support -- will be most useful to you and your project(s) **one year from now.** Which is most likely to make your work easier?

Then you&#39;ll have your answer. And if you still can&#39;t choose, pick Dapper (just a random selection I made :-)  As the Cheshire Cat says, if you don&#39;t really know where you want to go, it doesn&#39;t matter which road you choose.

PetaPoco&#39;s documentation seems more mature than others. It seems like it is the safest route. 

i havent triend any of those. by default i always base my decision on number of lines of resulting client code and type safety. of course there are number of other metrics you should take into account but if your project is not constrained by any special (exotic) requirements those two are generally appliable.
btw. i am aware about controversy my response may lead to ;)

I have a major problem with project configurations. Everything started when I wanted to add new solution configuration (named &quot;Dev_WithSource&quot;) based on existing &quot;Debug&quot; configuration and checked &quot;Create project configurations&quot;. For some reason project configurations were registered inside sln file, properly showing in Configuration manager, but &quot;PropertyGroup Condition&quot; blocks in csproj files weren&#39;t created. That resulted in &quot;OutputPath not set ...&quot; error.  

So, I tried to repeat whole procedure. After deleting all lines mentioning &quot;Dev_WithSource&quot; from sln file, &quot;Dev_WithSource&quot; project configurations are still showing in configuration  manager. I searched all csproj and sln file in my solution. Neither of them contain text &quot;Dev_WithSource&quot;.  

After all that I event tried developing add-in. I can fetch phantom configurations with project.ConfigurationManager.ConfigurationRowNames but I also can&#39;t delete them. 
Am I missing something? Are those configurations stored in some other files and not csproj/sln?

Thanks. 

Visual studio - can&#39;t remove project configurations

I failed to parse an ISO-8601 date &quot;2011-04-26T13:16:50Z&quot; on IE8 and Safari 5, but it worked on Chrome 10, FF4. Support seems to be quite mixed? 

Does anyone know the actual status of which browsers can parse this format? I assume IE6, and 7 will fail too.

    var d = Date.parse(&quot;2011-04-26T13:16:50Z&quot;);

JavaScript: Which browsers support parsing of ISO-8601 Date String with Date.parse

Trying to decide between [Dapper][1], [Massive][2] and [PetaPoco][3]. I do like simplicity of Dapper, flexibility of Massive and POCO support in PetaPoco but am currently procrastinating about which one to choose for my next project.

I do realise that, to a large extent, it&#39;s the matter of personal taste, but believe it will be valuable to hear some opinions on the subject, especially from people who tried more than one of these, err, libraries (what *is* the right term: library, file, framework?)

  [1]: http://code.google.com/p/dapper-dot-net/
  [2]: https://github.com/robconery/massive
  [3]: http://www.toptensoftware.com/petapoco/


Which Micro ORM to use?

Trying to decide between <a href="http://code.google.com/p/dapper-dot-net/" target="_blank" rel="noopener noreferrer">Dapper</a>, <a href="https://github.com/robconery/massive" target="_blank" rel="noopener noreferrer">Massive</a> and <a href="http://www.toptensoftware.com/petapoco/" target="_blank" rel="noopener noreferrer">PetaPoco</a>. I do like simplicity of Dapper, flexibility of Massive and POCO support in PetaPoco but am currently procrastinating about which one to choose for my next project.
I do realise that, to a large extent, it's the matter of personal taste, but believe it will be valuable to hear some opinions on the subject, especially from people who tried more than one of these, err, libraries (what is the right term: library, file, framework?)

I would like a Covariant collection whose items can be retrieved by index.  IEnumerable is the only .net collection that I&#39;m aware of that is Covariant, but it does not have this index support.

Specifically, I&#39;d like to do this:

	List&lt;Dog&gt; dogs = new List&lt;Dog&gt;();

	IEnumerable&lt;Animal&gt; animals = dogs;
	IList&lt;Animal&gt; animalList = dogs; // This line does not compile

Now, I&#39;m aware of why this is a problem.  List implements `ICollection` that has an Add method.  By up casting to `IList` of Animals, it would allow subsequent code to add any type of animal which is not allowed in the &quot;real&quot; `List&lt;Dog&gt;` collection.

So is anyone aware of a collection that supports index lookups that is also covariant?  I would like to not create my own.





Covariance and IList

I have a problem with MVC3

I&#39;m trying to use `@Html.ActionLink()` to generate a Link for titles in my blog project.

Using constant strings in `ActionLink` works just dandy, but if I use `Posts.Title` (the Title of the current Post model being looped), I get this exception:

    CS1973: &#39;System.Web.Mvc.HtmlHelper&lt;dynamic&gt;&#39; has no applicable method 
    named &#39;ActionLink&#39; but appears to have an extension method by that name.  
    Extension methods cannot be dynamically dispatched. Consider casting  
    the dynamic arguments or calling the extension method without the  
    extension method syntax.

Html.ActionLink cannot be dynamically dispatched

Whenever I have local variables in a method, ReSharper suggests to convert them to constants:

    // instead of this:
    var s = &quot;some string&quot;;
    var flags = BindingFlags.Public | BindingFlags.Instance;
    
    // ReSharper suggest to use this:
    const string s = &quot;some string&quot;;
    const BindingFlags flags = BindingFlags.Public | BindingFlags.Instance;

Given that these are really constant values (and not variables) I understand that ReSharper suggest to change them to const.

But apart from that, is there any other advantage when using const (e.g. better performance) which justifies using `const BindingFlags` instead of the handy and readable `var` keyword?

BTW: I just found a similar question here: https://stackoverflow.com/questions/909681/resharper-always-suggesting-me-to-make-const-string-instead-of-string, but I think it is more about fields of a class where my question is about local variable/consts.

Advantages of using const instead of variables inside methods

I am attempting to consume a web service through its corresponding wsdl. This service is dependent upon authentication conforming to [Web Services Security Basic Security Profile 1.0][1] including that the correct xmls namespace of http://docs.oasis-open.org/wss/2004/01/oasis-200401wss-wssecurity-secext-1.0.xsd must be included in the request.

Example:

    &lt;wsse:UsernameToken xmlns:wsse=&#39;http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd&#39; &gt;
       &lt;wsse:Username&gt;
          Bob
       &lt;/wsse:Username&gt;
       &lt;wsse:Password Type=&#39;http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText&#39;&gt;
          1234
       &lt;/wsse:Password&gt;
    &lt;/wsse:UsernameToken&gt;

  [1]: http://www.ws-i.org/profiles/basicsecurityprofile-1.0.html#UsernameToken

My first attempts were along the lines of `Add Service Reference` targeting the wsdl and from the generated proxies using them as such

    ServicePointManager.ServerCertificateValidationCallback = 
        (object s, X509Certificate certificate, X509Chain chain,
                         SslPolicyErrors sslPolicyErrors) =&gt; true;
    
    var basicHttpBinding = new BasicHttpBinding(BasicHttpSecurityMode.Transport);
    basicHttpBinding.Security.Transport.ClientCredentialType = 
                                                    HttpClientCredentialType.Basic;
    
    var endpoint = new EndpointAddress(&quot;https://secure-ausomxana.crmondemand.com/...&quot;
               
    using (var client = new ContactClient(basicHttpBinding, endpoint))
    {
                    
        var credential = client.ClientCredentials.UserName;
        credential.UserName = &quot;bob&quot;;
        credential.Password = &quot;1234&quot;;
    
        var input = ...    
        var output = client.ContactQueryPage(input);
    }

However attempting to interrogate the SOAP messages with Fiddler I see that no UsernameToken element has been added.

What is the correct way to fulfill this contract?

**Edit:** following the response from @John Saunders  I attempted to alter my code to use a wsHttpBinding

    var wsHttpBinding = new WSHttpBinding(SecurityMode.Transport);
    wsHttpBinding.Security.Transport.ClientCredentialType =
                                             HttpClientCredentialType.Basic;

Using this binding the SOAP message becomes 

    &lt;s:Envelope xmlns:s=&quot;http://www.w3.org/2003/05/soap-envelope&quot; xmlns:a=&quot;http://www.w3.org/2005/08/addressing&quot;&gt;
      &lt;s:Header&gt;
        &lt;a:Action s:mustUnderstand=&quot;1&quot;&gt;document/urn:crmondemand/ws/ecbs/contact/10/2004:ContactQueryPage&lt;/a:Action&gt;
        &lt;a:MessageID&gt;urn:uuid:17807f44-1fcasfdsfd&lt;/a:MessageID&gt;
        &lt;a:ReplyTo&gt;
          &lt;a:Address&gt;http://www.w3.org/2005/08/addressing/anonymous&lt;/a:Address&gt;
        &lt;/a:ReplyTo&gt;
        &lt;a:To s:mustUnderstand=&quot;1&quot;&gt;https://secure-ausomxana.crmondemand.com/Services/Integration&lt;/a:To&gt;
      &lt;/s:Header&gt;
      &lt;s:Body xmlns:xsi=&quot;http://www.w3.org/2001/XMLSchema-instance&quot; xmlns:xsd=&quot;http://www.w3.org/2001/XMLSchema&quot;&gt;
        &lt;ContactQueryPage_Input xmlns=&quot;urn:crmondemand/ws/ecbs/contact/10/2004&quot;&gt;
          &lt;ListOfContact xmlns=&quot;urn:/crmondemand/xml/Contact/Query&quot;&gt;
            &lt;Contact&gt;
              &lt;Id&gt;1-asdfd&lt;/Id&gt;
            &lt;/Contact&gt;
          &lt;/ListOfContact&gt;
        &lt;/ContactQueryPage_Input&gt;
      &lt;/s:Body&gt;
    &lt;/s:Envelope&gt;

This adds the Header element, as opposed to the `wsse:UsernameToken` element for reference the original soap message using the BasicHttpBinding is

    &lt;s:Envelope xmlns:s=&quot;http://schemas.xmlsoap.org/soap/envelope/&quot;&gt;
      &lt;s:Body xmlns:xsi=&quot;http://www.w3.org/2001/XMLSchema-instance&quot; xmlns:xsd=&quot;http://www.w3.org/2001/XMLSchema&quot;&gt;
        &lt;ContactQueryPage_Input xmlns=&quot;urn:crmondemand/ws/ecbs/contact/10/2004&quot;&gt;
          &lt;ListOfContact xmlns=&quot;urn:/crmondemand/xml/Contact/Query&quot;&gt;
            &lt;Contact&gt;
              &lt;Id&gt;1-asdfds&lt;/Id&gt;
            &lt;/Contact&gt;
          &lt;/ListOfContact&gt;
        &lt;/ContactQueryPage_Input&gt;
      &lt;/s:Body&gt;
    &lt;/s:Envelope&gt;

If I change the binding to be 

    var wsHttpBinding = new WSHttpBinding(SecurityMode.TransportWithMessageCredential);
    wsHttpBinding.Security.Transport.ClientCredentialType = HttpClientCredentialType.Basic;
    wsHttpBinding.Security.Message.ClientCredentialType = MessageCredentialType.UserName;

The SOAP message I get out is

    &lt;s:Envelope xmlns:s=&quot;http://www.w3.org/2003/05/soap-envelope&quot; xmlns:a=&quot;http://www.w3.org/2005/08/addressing&quot; xmlns:u=&quot;http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-utility-1.0.xsd&quot;&gt;
      &lt;s:Header&gt;
        &lt;a:Action s:mustUnderstand=&quot;1&quot;&gt;http://schemas.xmlsoap.org/ws/2005/02/trust/RST/SCT&lt;/a:Action&gt;
        &lt;a:MessageID&gt;urn:uuid:eeb75457-f29e-4c65-b4bf-b580da26e0c5&lt;/a:MessageID&gt;
        &lt;a:ReplyTo&gt;
          &lt;a:Address&gt;http://www.w3.org/2005/08/addressing/anonymous&lt;/a:Address&gt;
        &lt;/a:ReplyTo&gt;
        &lt;a:To s:mustUnderstand=&quot;1&quot;&gt;https://secure-ausomxana.crmondemand.com/Services/Integration&lt;/a:To&gt;
        &lt;o:Security xmlns:o=&quot;http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd&quot; s:mustUnderstand=&quot;1&quot;&gt;
          &lt;u:Timestamp u:Id=&quot;_0&quot;&gt;
            &lt;u:Created&gt;2011-05-02T13:30:09.360Z&lt;/u:Created&gt;
            &lt;u:Expires&gt;2011-05-02T13:35:09.360Z&lt;/u:Expires&gt;
          &lt;/u:Timestamp&gt;
          &lt;o:UsernameToken u:Id=&quot;uuid-dc3605a0-6878-42f4-b1f2-37d5c04ed7b4-2&quot;&gt;
            &lt;o:Username&gt;Bob&lt;/o:Username&gt;
            &lt;o:Password Type=&quot;http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText&quot;&gt;1234&lt;/o:Password&gt;
          &lt;/o:UsernameToken&gt;
        &lt;/o:Security&gt;
      &lt;/s:Header&gt;
      &lt;s:Body&gt;
        &lt;t:RequestSecurityToken xmlns:t=&quot;http://schemas.xmlsoap.org/ws/2005/02/trust&quot;&gt;
          &lt;t:TokenType&gt;http://schemas.xmlsoap.org/ws/2005/02/sc/sct&lt;/t:TokenType&gt;
          &lt;t:RequestType&gt;http://schemas.xmlsoap.org/ws/2005/02/trust/Issue&lt;/t:RequestType&gt;
          &lt;t:Entropy&gt;
            &lt;t:BinarySecret u:Id=&quot;uuid-7195ad74-580b-4e52-9e2c-682e5a684345-1&quot; Type=&quot;http://schemas.xmlsoap.org/ws/2005/02/trust/Nonce&quot;&gt;bI4xuyKwZ8OkQYBRnz2LDNV+zhIOnl0nwP24yI1QAwA=&lt;/t:BinarySecret&gt;
          &lt;/t:Entropy&gt;
          &lt;t:KeySize&gt;256&lt;/t:KeySize&gt;
        &lt;/t:RequestSecurityToken&gt;
      &lt;/s:Body&gt;
    &lt;/s:Envelope&gt;

This seems to be very close however this appears to have actually encrypted the body of the soap message which is something I do NOT want to happen.

If I specify `wsHttpBinding.Security.Message.ClientCredentialType = MessageCredentialType.UserName;` with only using `SecurityMode.Transport` it goes back to where it says its anonymous. 

What is the final hurdle I&#39;m not able to clear on this?

**Final Solution:** Figured I&#39;d post this incase it helps someone, there&#39;s not really much different here other the UserToken object is wrapped in a Security node which is what my service provider required and seems to be how its output from my previous examples from what I could get generated.

    &lt;system.serviceModel&gt;
      &lt;bindings&gt;    
        &lt;basicHttpBinding&gt;
          &lt;binding name=&quot;Contact&quot; closeTimeout=&quot;00:01:00&quot; openTimeout=&quot;00:01:00&quot;
              receiveTimeout=&quot;00:10:00&quot; sendTimeout=&quot;00:01:00&quot; allowCookies=&quot;false&quot;
              bypassProxyOnLocal=&quot;false&quot; hostNameComparisonMode=&quot;StrongWildcard&quot;
              maxBufferSize=&quot;524288&quot; maxBufferPoolSize=&quot;524288&quot; maxReceivedMessageSize=&quot;524288&quot;
              messageEncoding=&quot;Text&quot; textEncoding=&quot;utf-8&quot; transferMode=&quot;Buffered&quot;
              useDefaultWebProxy=&quot;true&quot;&gt;
            &lt;readerQuotas maxDepth=&quot;32&quot; maxStringContentLength=&quot;65536&quot; maxArrayLength=&quot;131072&quot;
                maxBytesPerRead=&quot;32768&quot; maxNameTableCharCount=&quot;131072&quot; /&gt;
            &lt;security mode=&quot;Transport&quot;&gt;
              &lt;transport clientCredentialType=&quot;None&quot; proxyCredentialType=&quot;None&quot;
                  realm=&quot;&quot; /&gt;
              &lt;message clientCredentialType=&quot;UserName&quot; algorithmSuite=&quot;Default&quot; /&gt;
            &lt;/security&gt;
          &lt;/binding&gt;         
        &lt;/basicHttpBinding&gt;
      &lt;/bindings&gt;
      &lt;client&gt;
        &lt;endpoint address=&quot;https://secure-ausomxana.crmondemand.com/Services/Integration&quot;
           binding=&quot;basicHttpBinding&quot; bindingConfiguration=&quot;Contact&quot;
           contract=&quot;OnDemandContactService.Contact&quot; name=&quot;OnDemand.Contact.Endpoint&quot;&gt;
          &lt;headers&gt;        
            &lt;wsse:Security xmlns:wsse=&quot;http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-wssecurity-secext-1.0.xsd&quot;&gt;
              &lt;wsse:UsernameToken&gt;
                &lt;wsse:Username&gt;USERNAME&lt;/wsse:Username&gt;
                &lt;wsse:Password Type=&quot;http://docs.oasis-open.org/wss/2004/01/oasis-200401-wss-username-token-profile-1.0#PasswordText&quot;&gt;PASSWORD&lt;/wsse:Password&gt;
              &lt;/wsse:UsernameToken&gt;
            &lt;/wsse:Security&gt;
          &lt;/headers&gt;
        &lt;/endpoint&gt;
      &lt;/client&gt;
    &lt;/system.serviceModel&gt;

See https://stackoverflow.com/questions/14327960/with-c-wcf-soap-consumer-that-uses-wsse-plain-text-authentication/14334760 for how to configure it using code and not config

Correct way communicate WSSE Usernametoken for SOAP webservice

I found NPOI is very good to write Excel files with C#.

But I want to open, read and modify Excel files in C#.

How can I do this?

How to read file using NPOI

I currently use this regular expression to check if a string conforms to a few conditions.

The conditions are 
string must be between 8 and 15 characters long. 
string must contain at least one number. 
string must contain at least one uppercase letter. 
string must contain at least one lowercase letter. 

`(?!^[0-9]*$)(?!^[a-zA-Z]*$)^([a-zA-Z0-9]{8,15})$`


It works for the most part, but it does not allow special character. Any help modifying this regex to allow special character is much appreciated.


Regular Expression for password validation

I found out that some classes use the `[Serializable]` attribute.

 - What is it?   
 - When should I use it?   
 - What kinds of benefits will I get?  


What is [Serializable] and when should I use it?

Is it possible to declare a method within another method in C#?

For example like that:


    void OuterMethod()
    {
        int anything = 1;
        InnerMethod();     // call function
        void InnerMethod()
        {
            int PlitschPlatsch = 2;
        }
    }



C#: Function in Function possible?

I am interested in using Dapper - but from what I can tell it only supports Query and Execute.  I do not see that Dapper includes a way of Inserting and Updating objects.

Given that our project (most projects?) need to do inserts and updates, what is the best practice for doing Inserts and Updates alongside dapper?

Preferably we would not have to resort to the ADO.NET method of parameter building, etc.

The best answer I can come up with at this point is to use LinqToSQL for inserts and updates.  Is there a better answer?

Performing Inserts and Updates with Dapper

I am very impressed with the results of [Dapper Micro ORM][1] for stackoverflow.com. I am considering it for my new project and but I have one concern about that some times my project requires to have Stored Procedure and I have search a lot on web but not found anything with stored procedure. So is there any way to have Dapper work with a stored procedure?

Please let me know if it is possible otherwise I have to extend it in my way.


  [1]: https://github.com/StackExchange/dapper-dot-net

Is there a way to call a stored procedure with Dapper?

I&#39;m rewriting a project to use Node.js. I&#39;d like to keep using MySQL as the DB (even though I don&#39;t mind rewriting the schema).
I&#39;m looking for a simple-to-use, reasonable-performance ORM, which supports caching, many-to-one and many-to-many relations.
From the MySQL ORMs I could find, [persistencejs](https://github.com/coresmart/persistencejs) and [sequelize](http://sequelizejs.com) seem the most mature. 
Do you have experience with either? What are the relevant pros and cons I should be aware of in my decision?

Which ORM should I use for Node.js and MySQL?

I have a model `Coupon`, and a model `Photo` with a `ForeignKey` to it:

    class Photo(models.Model):
        coupon = models.ForeignKey(Coupon,
                                   related_name=&#39;description_photos&#39;)
        title = models.CharField(max_length=100)
        image = models.ImageField(upload_to=&#39;images&#39;)

I set up inlines in the admin so now I&#39;m able to add photos to a coupon from the admin.

I attempt to add one, and upload is successful, but then I get Django&#39;s debug page with this error:

    IntegrityError at /admin/coupon/coupon/321/
    (1452, &#39;Cannot add or update a child row: a foreign key constraint fails (`my_project`.`coupon_photo`, CONSTRAINT `coupon_id_refs_id_90d7f06` FOREIGN KEY (`coupon_id`) REFERENCES `coupon_coupon` (`id`))&#39;)

What is this and how can I solve this problem?

(If it matters, this is a MySQL database.)

**EDIT:** I tried it on an Sqlite3 database that has a slightly different dataset, and it worked, so perhaps there&#39;s loose data in my current DB? How can I find it and delete it?

Django &quot;Cannot add or update a child row: a foreign key constraint fails&quot;

I keep hearing about the Entity Framework fluent-api but I am struggling to find a good reference on this. What is it?

We use the entity framework and the modeling tool provided. Is that all that is? Or is it something different?

Similarly, if it&#39;s not too broad a question, what is POCO? I know it stands for Plain Old CLR Objects, but what does that mean to me as somebody who uses EF already with the designer model tool? If that question is too vague then please ignore it. I&#39;m just learning here and any information you are willing to provide is helpful.

Content Type	Original Author	Original Content on Stackoverflow
Question	georged	View Question on Stackoverflow
Solution 1 - C#	Roy Dictus	View Answer on Stackoverflow
Solution 2 - C#	suhair	View Answer on Stackoverflow
Solution 3 - C#	Boris Bucha	View Answer on Stackoverflow

Which Micro ORM to use?

C# Problem Overview

C# Solutions

Solution 1 - C#

Solution 2 - C#

Solution 3 - C#

JavaScript: Which browsers support parsing of ISO-8601 Date String with Date.parse

Visual studio - can't remove project configurations

Attributions