Use Sql connection in a separate file in Azure Function

Question

I am using Azure function to connect to Sql database and retrieve values. I am able to install the necessary Nuget packages and perform Sql connection and querying in the Run() function

I wish to keep this database access function alone in a separate file, and return value to the main function(Run() in this case). But when i create a new class in the Azure function project and write SQL connection code, no "using" statements can be used or installed packages can be used.

I am new to Azure functions and may be i am wrong in this approach. Can you help me out? Thanks.

.

you need to add the needed using statements. Quick FIx sould help out. Also, you are missing a method definition. — Thomas D.
– Thomas D., Commented Aug 4, 2020 at 13:20

Thiago Custodio · Accepted Answer · 2020-08-04 13:21:02Z

1

You just need to wrap your code in a method. Here's a sample:

public class SqlQuery
{
    private string cs = Environment.GetEnvironmentVariable("SqlConnectionString");
    
    public void Query()
    {
        using(var conn = new SqlConnection(cs))
        {
            conn.Open();
            var cmd = conn.CreateCommand("SELECT * FROM Table");
            var dr = cmd.ExecuteReader();

            if(dr == null) return;
                        
            while(dr.Read())
            {

            }
        }
    }
    
}

answered Aug 4, 2020 at 13:21

Thiago Custodio

18.4k9 gold badges50 silver badges99 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thiago Custodio Over a year ago

you're welcome, don't forget to change the return type from void to the object you want and also include the return statement after the while.

Rakesh Suryawanshi · Accepted Answer · 2020-08-04 13:26:56Z

1

the screenshot you shared contains a class and has started implementation inside the class, whereas you should be creating at least one method inside your class and then add your code into the method which returns the data you expect. try that it should work!

public class SqlQuery{
public void ExecuteReader()
{
    private string cs =Environment.GetEnvironmentVariable("SqlConnectionString");
    using(var conn = new SqlConnection(cs))
    {
          conn.Open();
          var cmd = conn.CreateCommand("SELECT * FROM Table");
          var dr = cmd.ExecuteReader();
          if(dr == null) return;
          while(dr.Read())
          {

         }
    }
}}

edited Aug 4, 2020 at 13:26

answered Aug 4, 2020 at 13:20

Rakesh Suryawanshi

5401 gold badge8 silver badges19 bronze badges

1 Comment

Deepak Over a year ago

Yea i missed that out in a hurry writing! Thanks.

Collectives™ on Stack Overflow

Use Sql connection in a separate file in Azure Function

2 Answers 2

1 Comment

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related