Upload file store in database

Question

 Hi,

I am using silverlight 4 based application .

Actually i have to store any kind of file in my database and that file have no size criteria so could you please help for setting the maximum file size and store that file in database.

 

Thanks in advance.

Answer 1

check this article

http://www.databasejournal.com/features/mssql/article.php/3719221/Storing-Images-and-BLOB-files-in-SQL-Server.htm

most often you will use varbinary(max) data type in sql server to store this kind of data.

Answer 2

 Thanks for replying ..

I am using wcf service for communication database.

but wcf service accepts only 64 kb data file only.

what setting i have to do in wcf sertvice configuiration or client reference configuiration. 

Answer 3

 You should send file using chunks, store to server temporary storage and then on final step, upload file to database

http://silverlightfileupld.codeplex.com/

http://slfileupload.codeplex.com/

Answer 4

 

 Thanks for replying ..but still i did'nt get the answer...Please help me out...

I am using wcf service for communication database.

but wcf service accepts only 16kb data file only.actually i am passing byte[] in wcf method and wcf is stroing  that byte value in database.

what setting i have to do in wcf sertvice configuiration or client reference configuiration. 

i have done all those setting still above to 20 kb file is not getting the service.

---------------------------------------------------------------------------------------------------------------------------------------------

Make sure your WCF service is configured properly.  By default WCF minmizes the maximum number of characters you can upload (8,000) and max number of chars in the buffer and max number of items to serialize etc.

 1) Under the tool menu find WCF service configuration Editor and open it. Open the Web.config under your Web project that host your service:

• Click the Bindings folder and add a new basicHttpBinding give it a name something like "LargeBuffer".
• Change the number in MaxBufferSize/MaxReceivedMessageSize/MaxArrayLenght/MaxBytesPerRead/MaxDepth/MaxNameTableCharCount/MaxStringContentLenght to a large number. Those fields are integer fields. So the max number you can enter is 2147483647 which is the upper limit of a integer.
• Find the first endpoint under Service Folder for WCFSilverlightWeb.WCFService, Click the BindingConfiguration and select the "LargeBuffer" binding you just created.
• Save the web.config.

2) Use the same WCF service configuration Editor to open ServiceReferences.ClientConfig file under your Silverlight project.

• You should see your service under Client/EndPoints folder. Open that endpoint. That endpoint has bindingConfiguration set to BasicHttpBinding_[YourService]. Goto that binding and change the MaxBufferSize/MaxReceivedMessageSize(Just those 2 fields, not fields under the ReaderQuotasProperties)  to the same large number you set in the Web.Config.
• Save the Client Config file

-------------------------------------------------------------------------------------------------------------------------------------------------------------
Now i should be upload a file up to 4MB.but its not working wt to do....Plz tell me

 

Answer 5

Please check this "Using WCF and silverlight to create a restful file upload utility":

http://zleek.wordpress.com/2009/02/12/using-silverlight-and-wcf-to-create-a-restful-file-upload-utility/

Answer 6

 thanks nangua for replying ....but wt link u suggest that is only for uploading maximum size file in server(web) folder.

my issue is  that i am passing byte array to WCF service for storing that byte array data in database.

16 kb byte array data is going without any problem but after that any big size data is not connecting with service.

 

 

Please silverlight team suggest me proper link.....

Answer 7

Increase web service timeout and message quota in your (ServiceReferences.ClientConfig) http://usamawahabkhan.blogspot.com/2010/05/silverlight-load-large-data.html here is example

Answer 8

 Hi usama,

i set the time first serviceReference.ClientConfig file. but did'nt get right response.

 

maxBufferSize="2147483647" maxReceivedMessageSize="2147483647" receiveTimeout="00:20:00"   sendTimeout="00:20:00" openTimeout="00:20:00" closeTimeout="00:20:00"

i set that in web.config also...but no result...wt to do..

 

Answer 9

 

 hi silverlight team,

i am stuck on here please provide me the right solution for that in silverlight 4.0

thanks.

Answer 10

Can you post the web.config file. and the servicereference.clientconfig file if you don't mind?

thanks

Answer 11

 hi shihalv,

this is my web.config...

=============================================================================

<?xml version="1.0"?>

<!--
  For more information on how to configure your ASP.NET application, please visit
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->


<configuration>
  <connectionStrings>
    <add name="SyngrafiiConnectionString" connectionString="Data Source=10.0.7.53;Initial Catalog=Syngrafii;Persist Security Info=True;User ID=appollo;Password=appollo"
        providerName="System.Data.SqlClient" />
  </connectionStrings>
  <location allowOverride="false">
    <system.web>
      <trust level="Full" originUrl="" />
      <httpRuntime
  executionTimeout="110"
  maxRequestLength="4096"
  requestLengthDiskThreshold="80"
  useFullyQualifiedRedirectUrl="false"
  minFreeThreads="8"
  minLocalRequestFreeThreads="4"
  appRequestQueueLimit="5000"
  enableKernelOutputCache="true"
  enableVersionHeader="true"
  requireRootedSaveAsPath="true"
  enable="true"
  shutdownTimeout="90"
  delayNotificationTimeout="5"
  waitChangeNotification="0"
  maxWaitChangeNotification="0"
  enableHeaderChecking="true"
  sendCacheControlHeader="true"
  apartmentThreading="false" />

      <compilation debug="true" targetFramework="4.0" />
    </system.web>
  </location>
    <system.serviceModel>
      <diagnostics wmiProviderEnabled="true">
        <messageLogging maxMessagesToLog="30000"
                logEntireMessage="true"
                logMessagesAtServiceLevel="true"
                logMalformedMessages="true"
                logMessagesAtTransportLevel="true">
        </messageLogging>
      </diagnostics>
   
  

      <bindings>
            <basicHttpBinding>
                <binding name="LargeBuffer"   closeTimeout="00:01:00"
                  openTimeout="00:10:00" receiveTimeout="01:00:00" sendTimeout="01:00:00"
                  allowCookies="false" bypassProxyOnLocal="false" hostNameComparisonMode="StrongWildcard"
                  maxBufferSize="655360" maxBufferPoolSize="524288" maxReceivedMessageSize="2147483648"
                  messageEncoding="Mtom" transferMode="Streamed"
                  useDefaultWebProxy="true">
                          <!--maxBufferSize="2147483647" maxReceivedMessageSize="2147483647" receiveTimeout="01:00:00"
                         sendTimeout="01:00:00" openTimeout="00:20:00" closeTimeout="00:20:00" transferMode="Streamed" >
                    <readerQuotas maxDepth="2147483647" maxStringContentLength="2147483647"
                        maxArrayLength="2147483647" maxBytesPerRead="2147483647" maxNameTableCharCount="2147483647" />-->
               
                </binding>
            </basicHttpBinding>
        </bindings>
      <services>
        <service name="SilverAnnotation.SyngrafiiService">
          <endpoint address="/BasicSoap" binding="basicHttpBinding" bindingConfiguration="LargeBuffer"
            name="basicHttpBinding" contract="SilverAnnotation.ISyngrafiiService" />
          <!--<endpoint address="mex" binding="mexHttpBinding" contract="IMetadataExchange" />-->
        </service>
      </services>
        <behaviors>
            <serviceBehaviors>
                <behavior name="">
                    <serviceMetadata httpGetEnabled="true" />
                    <serviceDebug includeExceptionDetailInFaults="false" />
                </behavior>
            </serviceBehaviors>
        </behaviors>
        <serviceHostingEnvironment aspNetCompatibilityEnabled="true" />
    </system.serviceModel>
  <system.diagnostics>
    <sources>
      <source name="System.ServiceModel" switchValue="Verbose, ActivityTracing" >
        <listeners>
          <add name="xml" />
        </listeners>
      </source>
      <source name="System.ServiceModel.MessageLogging" switchValue="Verbose">
        <listeners>
          <add name="xml" />
        </listeners>
      </source>
    </sources>
    <sharedListeners>
      <add name="xml" type="System.Diagnostics.XmlWriterTraceListener" initializeData="MyAppTraceFile.svclog" />
    </sharedListeners>
    <trace autoflush="true" />
  </system.diagnostics>
</configuration>

====================================================================

and this is service.clientconfig ...

====================================================================

<configuration>
    <system.serviceModel>
        <bindings>
            <basicHttpBinding>
                <binding name="BasicHttpBinding_ISyngrafiiService" maxBufferSize="2147483647"
                    maxReceivedMessageSize="2147483647"  closeTimeout="00:01:00"
                  openTimeout="00:10:00" receiveTimeout="01:00:00" sendTimeout="01:00:00">
                    <security mode="None" />
                </binding>
            </basicHttpBinding>
        </bindings>
        <client>
            <endpoint address="http://localhost:2358/SyngrafiiService.svc"
                binding="basicHttpBinding" bindingConfiguration="BasicHttpBinding_ISyngrafiiService"
                contract="SyngrafiiDataService.ISyngrafiiService" name="BasicHttpBinding_ISyngrafiiService" />
        </client>
    </system.serviceModel>
</configuration>

==============================================================================

 

thanks 

Answer 12

can you change your binding from

 

                <binding name="LargeBuffer"   closeTimeout="00:01:00"
                  openTimeout="00:10:00" receiveTimeout="01:00:00" sendTimeout="01:00:00"
                  allowCookies="false" bypassProxyOnLocal="false" hostNameComparisonMode="StrongWildcard"
                  maxBufferSize="655360" maxBufferPoolSize="524288" maxReceivedMessageSize="2147483648"
                  messageEncoding="Mtom" transferMode="Streamed"
                  useDefaultWebProxy="true">
                          <!--maxBufferSize="2147483647" maxReceivedMessageSize="2147483647" receiveTimeout="01:00:00" 
                         sendTimeout="01:00:00" openTimeout="00:20:00" closeTimeout="00:20:00" transferMode="Streamed" >
                    <readerQuotas maxDepth="2147483647" maxStringContentLength="2147483647"
                        maxArrayLength="2147483647" maxBytesPerRead="2147483647" maxNameTableCharCount="2147483647" />-->
                
                </binding>

 to

<binding name="LargeBuffer" closeTimeout="00:01:00" openTimeout="00:01:00" receiveTimeout="00:10:00" sendTimeout="00:01:00" allowCookies="false" bypassProxyOnLocal="false" hostNameComparisonMode="StrongWildcard" maxBufferSize="2147483647" maxBufferPoolSize="2147483647" maxReceivedMessageSize="2147483647" messageEncoding="Text" textEncoding="utf-8" transferMode="Buffered" useDefaultWebProxy="true">
          <readerQuotas maxDepth="2147483647" maxStringContentLength="2147483647" maxArrayLength="2147483647" maxBytesPerRead="2147483647" maxNameTableCharCount="2147483647" />
          <security mode="None">
            <transport clientCredentialType="None" proxyCredentialType="None" realm="" />
            <message clientCredentialType="UserName" algorithmSuite="Default" />
          </security>
        </binding>

 then configure serviceBehaviours like this

      <serviceBehaviors>
        <behavior name="SampleServiceBehaviors">
          <serviceMetadata httpGetEnabled="true" />
          <serviceDebug includeExceptionDetailInFaults="true" />
          <dataContractSerializer maxItemsInObjectGraph="2147483647" />
        </behavior>
      </serviceBehaviors>

 then use this service behaviour in your service like this

<service name="SilverAnnotation.SyngrafiiService" behaviorConfiguration="SampleServiceBehaviors">
          <endpoint address="/BasicSoap" binding="basicHttpBinding" bindingConfiguration="LargeBuffer"
            name="basicHttpBinding" contract="SilverAnnotation.ISyngrafiiService" />
          <!--<endpoint address="mex" binding="mexHttpBinding" contract="IMetadataExchange" />-->
        </service>

Answer 13

 hi shihalv,

it gives the Metadata publishing for this service is currently disabled. error..

from where it gets enable.

Answer 14

Can you try removing this line?

<serviceMetadata httpGetEnabled="true" />

sorry this hsa to be a trial and error, i just pick up what we hve in our projects which works.

Answer 15

 with <serviceMetadata httpGetEnabled="true" />

this line and without this line , in both case service says this...

i think its because of adding this feature behaviorConfiguration="SyngrafiiServiceBehaviors"....

=========================================================

Service

This is a Windows© Communication Foundation service.

Metadata publishing for this service is currently disabled.

If you have access to the service, you can enable metadata publishing by completing the following steps to modify your web or application configuration file:

1. Create the following service behavior configuration, or add the <serviceMetadata> element to an existing service behavior configuration:

<behaviors>
    <serviceBehaviors>
        <behavior name="MyServiceTypeBehaviors" >
            <serviceMetadata httpGetEnabled="true" />
        </behavior>
    </serviceBehaviors>
</behaviors>

2. Add the behavior configuration to the service:

<service name="MyNamespace.MyServiceType" behaviorConfiguration="MyServiceTypeBehaviors" >

Note: the service name must match the configuration name for the service implementation.

3. Add the following endpoint to your service configuration:

<endpoint contract="IMetadataExchange" binding="mexHttpBinding" address="mex" />

Note: your service must have an http base address to add this endpoint.

The following is an example service configuration file with metadata publishing enabled:

<configuration>
    <system.serviceModel>
 
        <services>
            <!-- Note: the service name must match the configuration name for the service implementation. -->
            <service name="MyNamespace.MyServiceType" behaviorConfiguration="MyServiceTypeBehaviors" >
                <!-- Add the following endpoint.  -->
                <!-- Note: your service must have an http base address to add this endpoint. -->
                <endpoint contract="IMetadataExchange" binding="mexHttpBinding" address="mex" />
            </service>
        </services>
 
        <behaviors>
            <serviceBehaviors>
                <behavior name="MyServiceTypeBehaviors" >
                    <!-- Add the following element to your service behavior configuration. -->
                    <serviceMetadata httpGetEnabled="true" />
                </behavior>
            </serviceBehaviors>
        </behaviors>
 
    </system.serviceModel>
</configuration>

For more information on publishing metadata please see the following documentation: http://go.microsoft.com/fwlink/?LinkId=65455.

 

Answer 16

Please retain the  <serviceMetadata httpGetEnabled="true" />

Can you try changing this

<service name="SilverAnnotation.SyngrafiiService" behaviorConfiguration="SampleServiceBehaviors">
          <endpoint address="/BasicSoap" binding="basicHttpBinding" bindingConfiguration="LargeBuffer"
            name="basicHttpBinding" contract="SilverAnnotation.ISyngrafiiService" />
          <!--<endpoint address="mex" binding="mexHttpBinding" contract="IMetadataExchange" />-->
        </service>

to

<service name="SilverAnnotation.SyngrafiiService" behaviorConfiguration="SampleServiceBehaviors">
          <endpoint binding="basicHttpBinding" bindingConfiguration="LargeBuffer"
            contract="SilverAnnotation.ISyngrafiiService" />
                  </service>

Answer 17

i have done setting in web.config same but because of that behavior name="SampleServiceBehaviors" >.

why its not taking servicebehaviors name ?

its showing the client reference error--

Metadata contains a reference that cannot be resolved: 'http://localhost:2358/SyngrafiiService.svc'. Content Type application/soap+xml; charset=utf-8 was not supported by service http://localhost:2358/SyngrafiiService.svc. The client and service bindings may be mismatched. The remote server returned an error: (415) Unsupported Media Type.

Answer 18

Answer 19

Can you check if this link helps?

http://social.msdn.microsoft.com/forums/en-US/wcf/thread/f29cd9c8-3c89-43d2-92ae-d2a270ab86b9/

Answer 20

 no Clue man ! wt to do ?

Answer 21

Hi brajeh ...

I have the same error like you !! and i cannot find a solution !!

if you have find the solution , can you tell me what you did please !!!

thanks and best regard