The integer represents the number of rows that were affected by your query. 

It returns an integer so you know if your query has worked. If zero is returned and you expected something to have changed then you know there is a problem. 

Because [DbCommand.ExecuteNonQuery][1] (which Dapper uses internally, no doubt) returns an int for the number of rows affected. Why? Because it&#39;s more or less free, and is about the only thing that you can reasonably return for a generic INSERT or UPDATE.



  [1]: https://msdn.microsoft.com/en-us/library/system.data.common.dbcommand.executenonquery(v=vs.110).aspx

# Goal

I want to make a custom keyboard that is only used within my app, not a system keyboard that needs to be installed.

# What I have read and tried

**Documentation**

- [App Extension Programming Guide: Custom Keyboard][1]
- [Custom Views for Data Input][2]

The first article above states:

&gt; Make sure a custom, systemwide keyboard is indeed what you want to
&gt; develop. To provide a fully custom keyboard for just your app or to
&gt; supplement the system keyboard with custom keys in just your app, the
&gt; iOS SDK provides other, better options. Read about custom input views
&gt; and input accessory views in Custom Views for Data Input in Text
&gt; Programming Guide for iOS.

That is what led me to the second article above. However, that article did not have enough detail to get me started.

**Tutorials**

- [iOS 8: Creating a Custom Keyboard in Swift][3]
- [How to make a custom keyboard in iOS 8 using Swift][4]
- [Xcode 6 Tutorial: iOS 8.0 Simple Custom Keyboard in Swift][5] 
- [Creating a Custom Keyboard Using iOS 8 App Extension][6]

I was able to get a working keyboard from the second tutorial in the list above. However, I couldn&#39;t find any tutorials that showed how to make an in app only keyboard as described in the [Custom Views for Data Input][2] documentation.

**Stack Overflow**

I also asked (and answered) these questions on my way to answering the current question.

- https://stackoverflow.com/questions/33497693/how-to-input-text-using-the-buttons-of-an-in-app-custom-keyboard
- [Delegates in Swift][7]

# Question

Does anyone have a minimal example (with even one button) of an in app custom keyboard? I am not looking for a whole tutorial, just a proof of concept that I can expand on myself.

  [1]: https://developer.apple.com/library/ios/documentation/General/Conceptual/ExtensibilityPG/Keyboard.html
  [2]: https://developer.apple.com/library/ios/documentation/StringsTextFonts/Conceptual/TextAndWebiPhoneOS/InputViews/InputViews.html
  [3]: http://code.tutsplus.com/tutorials/ios-8-creating-a-custom-keyboard-in-swift--cms-22344
  [4]: https://www.weheartswift.com/make-custom-keyboard-ios-8-using-swift/
  [5]: https://www.youtube.com/watch?v=W_Q91TY1J-o
  [6]: http://www.appcoda.com/custom-keyboard-tutorial/
  [7]: https://stackoverflow.com/a/33549729/3681880

A Swift example of Custom Views for Data Input (custom in-app keyboard)

Implementing a simple static site from flask, but the browser says template not found, the shell returned 404


    jinja2.exceptions.TemplateNotFound

    TemplateNotFound: template.html

The main python code:

    from flask import Flask, render_template
	app = Flask(__name__)


	@app.route(&quot;/&quot;)
	def template_test():
	    return render_template(&#39;template.html&#39;, my_string=&quot;Wheeeee!&quot;, my_list=[0,1,2,3,4,5])

	if __name__ == &#39;__main__&#39;:
	    app.run(debug=True)

I have the following file structure:

	flask_new_practice
	|--template/
		|--template.html
	|--run.py

Flask Template Not found

Anyone know why Dapper returns an int from `.Execute(...)` ? 

I can&#39;t find this documented anywhere.


Why does Dapper&#39;s .Execute(...) return an int?

<p>Anyone know why Dapper returns an int from <code>.Execute(...)</code> ?</p>
<p>I can't find this documented anywhere.</p>


In C++ it&#39;s actually possible to throw an exception by value without allocating memory on a heap, so this situation makes sense. But in .NET framework `OutOfMemoryException` is a reference type, therefore it is allocated on a heap. 
How does .NET framework allocates memory for `OutOfMemoryException` when there is not enough memory to create a new object?

How does .NET framework allocate memory for OutOfMemoryException?

I tried to use the conditional operator inside an interpolated string, but because it has a colon in it, the compiler thinks that after the colon comes a format string.

    $&quot;test {foo ? &quot;foo is true&quot; : &quot;foo is false&quot;}&quot;;

How can I use this type of statement?
The only thing that comes to my mind is something like this:

    var fooString = foo ? &quot;foo is true&quot; : &quot;foo is false&quot;;
    $&quot;test {fooString}&quot;;

C# interpolated string with conditional-operator

I am trying to use the EF7 InMemory provider for unit tests, but the persistent nature of the InMemory database between tests is causing me problems.

The following code demonstrates my issue. One test will work and the other test will always fail. Even though I set the `_context` to `null` between tests, the second test run will always have 4 records in it.

    [TestClass]
    public class UnitTest1
    {
        private SchoolContext _context;

        [TestInitialize]
        public void Setup()
        {
            Random rng = new Random();
            
            var optionsBuilder = new DbContextOptionsBuilder&lt;SchoolContext&gt;();
            optionsBuilder.UseInMemoryDatabase();

            _context = new SchoolContext(optionsBuilder.Options);
            _context.Students.AddRange(
                new Student { Id = rng.Next(1,10000), Name = &quot;Able&quot; },
                new Student { Id = rng.Next(1,10000), Name = &quot;Bob&quot; }
            );
            _context.SaveChanges();
        }

        [TestCleanup]
        public void Cleanup()
        {
            _context = null;
        }

        [TestMethod]
        public void TestMethod1()
        {
            Assert.AreEqual(2, _context.Students.ToList().Count());
        }

        [TestMethod]
        public void TestMethod2()
        {
            Assert.AreEqual(2, _context.Students.ToList().Count());
        }
    }

    public class Student
    {
        public int Id { get; set; }
        public string Name { get; set; }
    }

    public class SchoolContext : DbContext
    {
        public SchoolContext(DbContextOptions options) : base(options) { }

        public DbSet&lt;Student&gt; Students { get; set; }
    }

How can I reset an EF7 InMemory provider between unit tests?

I have added a new property to my existing model. It&#39;s a bool property with a default value of true. There are existing data in this table and I would like to set one specific row&#39;s new property to false right after creating the new field, in the Up method. 

    public override void Up()
    {
        AddColumn(&quot;dbo.RequestValidationErrors&quot;, &quot;IsBreaking&quot;,
             c =&gt; c.Boolean(nullable: false));
        using (Context ctx = new Context())
        {
            var validation = 
                ctx.RequestValidationErrorSet
                .FirstOrDefault
                    (x =&gt; x.WordCode == &quot;RequestValidationError.MoreThanOneItemFound&quot;);
                if (validation != null)
                {
                    validation.IsBreaking = false;
                    ctx.SaveChanges();
                }
            }
        }
    }
This way EF throws an error during saying 

&gt; System.InvalidOperationException: The model backing the
&gt; &#39;DbContext&#39; context has changed since the database was created.
&gt; Consider using Code First Migrations to update the database

Is it possible to change the database here or should I do it elsewhere?


Change data in migration Up method - Entity Framework

I have a console application that manages images. Now i need something like a preview of the Images within the console application. Is there a way to display them in the console?



Here is a comparison of the current character based answers:

Input:

[![enter image description here][1]][1]

Output:

[![enter image description here][2]][2]

[![enter image description here][3]][3]

[![enter image description here][4]][4]

[![enter image description here][5]][5]


  [1]: http://i.stack.imgur.com/teq9P.jpg
  [2]: http://i.stack.imgur.com/hLdnj.png
  [3]: http://i.stack.imgur.com/JmIGw.png
  [4]: http://i.stack.imgur.com/YrbAn.png
  [5]: http://i.stack.imgur.com/Z4DWa.png

Display a Image in a console application

I am having error while connecting to SQL Server:

[![enter image description here][1]][1]


Details in Stack Trace are:

    ===================================
    
    Cannot connect to ServerName.
    
    ===================================
    
    A connection was successfully established with the server, but then an error occurred during the login process. (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.) (.Net SqlClient Data Provider)
    
    ------------------------------
    For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&amp;EvtSrc=MSSQLServer&amp;EvtID=233&amp;LinkId=20476
    
    ------------------------------
    Server Name: ServerName
    Error Number: 233
    Severity: 20
    State: 0
    
    
    ------------------------------
    Program Location:
    
       at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
       at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParserStateObject.ReadSniError(TdsParserStateObject stateObj, UInt32 error)
       at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj)
       at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket()
       at System.Data.SqlClient.TdsParserStateObject.ReadBuffer()
       at System.Data.SqlClient.TdsParserStateObject.ReadByte()
       at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
       at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
       at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject, Boolean withFailover)
       at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
       at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
       at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionFactory.CreateNonPooledConnection(DbConnection owningConnection, DbConnectionPoolGroup poolGroup)
       at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
       at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
       at System.Data.SqlClient.SqlConnection.Open()
       at Microsoft.SqlServer.Management.SqlStudio.Explorer.ObjectExplorerService.ValidateConnection(UIConnectionInfo ci, IServerType server)
       at Microsoft.SqlServer.Management.UI.ConnectionDlg.Connector.ConnectionThreadUser()

  [1]: http://i.stack.imgur.com/FOQTX.png


**NOTE** **I have tried** 

 - closing, reopening Sql server Management Studio.

 - closing , reopen VS &amp; rebuild Solution

 - killed worker process accessing database.

 - login credentials are correct.
 
 - able to ping server to make sure its not down.



A connection was successfully established with the server, but then an error occurred during the login process. (Error Number: 233)

I have been debugging some slow code and it seems that the culprit is the EF code posted below. It takes 4-5 seconds when the query is evaluated at a later stage. I&#39;m trying to get it to run in under 1 second. 

I have tested this using the SQL Server Profiler, and it seems that a bunch of SQL scripts are executed. It also confirms that it takes 3-4 seconds before SQL server is done with the executions.

I have read other similar questions about the use of Include() and it does seem that there is a performance penalty when using it. I&#39;ve tried to split the below code into several different queries but it&#39;s not making much of difference.

Any idea how I can get the below to execute faster? 

Currently the web app I&#39;m working on is just showing an empty iframe while waiting for the below to complete. If I cannot get faster execution time I have to split it up and partially load the iframe with data or go with another asynchronous solution. Any ideas here would also be appreciated!

    using (var scope = new TransactionScope(TransactionScopeOption.Required, new TransactionOptions { IsolationLevel = System.Transactions.IsolationLevel.ReadUncommitted }))
            {
                formInstance = context.FormInstanceSet
                                    .Includes(x =&gt; x.Include(fi =&gt; fi.FormDefinition).Include(fd =&gt; fd.FormSectionDefinitions).Include(fs =&gt; fs.FormStateDefinitionEditableSections))
                                    .Includes(x =&gt; x.Include(fi =&gt; fi.FormDefinition).Include(fd =&gt; fd.FormStateDefinitions))
                                    .Includes(x =&gt; x.Include(fi =&gt; fi.FormSectionInstances).Include(fs =&gt; fs.FormFieldInstances).Include(ff =&gt; ff.FormFieldDefinition).Include(ffd =&gt; ffd.FormFieldMetaDataDefinition).Include(ffmdd =&gt; ffmdd.ComplexTypePropertyNames))
                                    .Include(x =&gt; x.CurrentFormStateInstance)      
                                    .Include(x =&gt; x.Files)
                                    .FirstOrDefault(x =&gt; x.FormInstanceIdentifier == formInstanceIdentifier);
                                         
                scope.Complete();
            }

Entity-framework code is slow when using Include() many times

What is the difference between scalar-valued, table-valued, and aggregate functions in SQL server? And does calling them from a query need a different method, or do we call them in the same way?

Difference between scalar, table-valued, and aggregate functions in SQL server?

FOR Example if I have: 

    DECLARE @Day int = 25
    DECLARE @Month int  = 10 
    DECLARE @Year int = 2016

I want to return

    2016-10-25
As Date or datetime


How to create a Date in SQL Server given the Day, Month and Year as Integers

I&#39;m trying to SET more than one value within the if else statement below, If I set one value it works, but if I set two values, it doesn&#39;t work:

    DECLARE @test1 varchar(60);
    DECLARE @test2 varchar(60);


    IF ((SELECT COUNT(*) FROM table WHERE table.Date &gt; &#39;2016-03-20&#39;) &gt; 10)
    SET @test1 = &#39;test1&#39;
    SET @test2 = &#39;test2&#39; 
    ELSE
    SET @test1 = &#39;testelse&#39;
    SET @test2 = &#39;testelse&#39;

&gt;Error message: &quot;Msg 156, Level 15, State 1, Line 9 &lt;br&gt;
&gt;Incorrect syntax near the keyword &#39;ELSE&#39;.&quot;

However it seems to be possible to have multiple SET variables after the else; this code works:

    IF ((SELECT COUNT(*) FROM table WHERE table.Date &gt; &#39;2016-03-20&#39;) &gt; 10)
    SET @test1 = &#39;test1&#39;
    ELSE
    SET @test1 = &#39;testelse&#39;
    SET @test2 = &#39;testelse&#39;

How can I do this correctly?

Content Type	Original Author	Original Content on Stackoverflow
Question	Drew R	View Question on Stackoverflow
Solution 1 - C#	CathalMF	View Answer on Stackoverflow
Solution 2 - C#	Mark Brackett	View Answer on Stackoverflow

Why does Dapper's .Execute(...) return an int?

C# Problem Overview

C# Solutions

Solution 1 - C#

Solution 2 - C#

Flask Template Not found

A Swift example of Custom Views for Data Input (custom in-app keyboard)

Attributions