Search results matching tag 'clr'

Online Data Transfer from MS Access to MS SQL Server automatically

manpreetsingh.MCA — Tue, 22 Sep 2009 04:00:00 GMT

Hi all,

        I am storming thru a problem of online data transfer from MS Access Database to MS SQL Server Database(at Data Center).
        The problem is when the data is added into a local system in MS Access(.mdb format) it should be exported immediately to the
        Data Center(in MS SQL Server). How can I acchieve the solution. One I searched is using Trigger to call XML Web Service and to
        export the the data automatically whenever the data is available.

Please give an example if possible...

waiting for response...urgently needed.....

Thanx a lot guies....

can't register serialized assembly DLL to mssql 2005

piratejackus — Mon, 15 Jun 2009 04:00:00 GMT

hi i have a project on .net which includes a trigger, written with c#, now after the steps to work with CLR like:

- generates serialization assembly -> on

- Allow unsafe code

- TRUSTWORTHY ON

form the article : http://www.codeproject.com/KB/database/SQLCLR.aspx

i couldn't succeed at last step which is to register my Serialized Assembly DLL to my database. here is what i tried:

CREATE ASSEMBLY [PCTrigger.XmlSerializers] FROM 'C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\HedeWebService\PCTrigger\bin\Debug\PCTrigger.XmlSerializers.dll'
WITH PERMISSION_SET=EXTERNAL_ACCESS

result:

Msg 6501, Level 16, State 7, Line 6
CREATE ASSEMBLY failed because it could not open the physical file 'C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\HedeWebService\PCTrigger\bin\Debug\PCTrigger.XmlSerializers.dll': 5(error not found).

i'm sure that the path of the PCTrigger.XmlSerializers.dll is right. I already read some comments about this error but couln't figure out. also i have another PCTrigger.XmlSerializers.dll file under [samepath]\obj\Debug\PCTrigger.XmlSerializers.dll , but i think i must use the one under \bin. i tried both of them and same result.

need help,thanks.

Re: j# icon needed

gerrylowry — Wed, 20 May 2009 04:00:00 GMT

Petrus, the process is a bit more complicated. Tom Archer describes it in his "Inside c#"*:

"Microsoft Intermediate Language and the JITters

To make it easy for language writers to port their languages to .NET, Microsoft developed ... Microsoft intermediate language (MSIL).

... compilers ... produce MSIL as output. MSIL itself is a complete language ... you can write applications in [MSIL].

... each compiler team makes its own decision about how much of the MSIL it will support.

... MSIL is then further compiled into native CPU instructions when the application is executed for the first time by the CLR.

... MSIL code cannot be executed directly—because it's not in a machine-executable format—the CLR compiles the MSIL by using a just-in-time (JIT) compiler (or JITter) into native CPU instructions as it processes the MSIL. JIT compiling occurs only as methods in the program are called. The compiled executable code is cached on the machine and is recompiled only if there's some change to the source code.

Three different JITters can be used to convert the MSIL into native code, depending on the circumstances:

Install-time code generation Install-time code generation will compile an entire assembly into CPU-specific binary code, ...
JIT The default JITter is called at run time ... the default if you don't explicitly run the PreJIT compiler.
EconoJIT Another run-time JITter, ... specifically designed for systems that have limited resources—for example, handheld devices with small amounts of memory .. "

Regards,
Gerry (Lowry)

* Inside c#, Microsoft Press, Copyright (c) 2001 by Tom Archer
Library of Congress Cataloging-in-Publication Data
Archer, Tom.
    Inside C# / Tom Archer.
      p. cm.
    Includes index.
    ISBN 0-7356-1288-9
    1. C# (Computer program language) I. Title.
   QA76.73.C154 A73   2001
  005.13'3--dc21                              2001030562

(a revised version is available: http://www.microsoft.com/learning/en/us/books/5861.aspx ).

More References:

http://msdn.microsoft.com/en-us/library/ht8ecch6.aspx
"Compiling MSIL to Native Code"

http://msdn.microsoft.com/en-us/library/c5tkafs1.aspx
"Compiling to MSIL"

http://technet.microsoft.com/en-us/library/bb496996.aspx
"UNIX Custom Application Migration Guide" ::
"Volume 4: Migrate Using .NET" :: "Chapter 1: Introduction to .NET"

Re: Typed ViewPage Using Generics Without Code Behind

koistya — Wed, 22 Oct 2008 04:00:00 GMT

You just have explicitly added Version, Culture and PublicKeyToken to my example though all they are optional as far as I know. Anyway I have also added them and have same issues with Intellisense:

Code Access Security

paladinckm — Sun, 03 Aug 2008 04:00:00 GMT

Hi all,

I am kind of newbie to the security era..Can any of you please post or guide me to nay video tutorials on topics like What is CAS ? How it is used in websites ? How to implement it ? etc

What is the role of Just In Time compiler .net architecture?

akhilkumars — Wed, 23 Jul 2008 04:00:00 GMT

Hello brothers ,,,,

I would like to know the importance of JIT compiler in .ner architecture. I have read that when CLR works it first compiles the source code into MSIL.Then the MSIL is interpreted to produce the native machine language.Then what does the JIT do?

Error accessing T-SQL UDF from CLR UDF

joerowe — Wed, 11 Jun 2008 04:00:00 GMT

Hi all,

I am experiencing the following error when I try to access a T-SQL UDF from within a SQL statement that I execute from a CLR UDF.

Msg 6522, Level 16, State 1, Line 2
A .NET Framework error occurred during execution of user-defined routine or aggregate "HelloWorldCLR": 
System.Data.SqlClient.SqlException: This statement has attempted to access data whose access is restricted by the assembly.
System.Data.SqlClient.SqlException: 
   at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.SqlInternalConnectionSmi.EventSink.DispatchMessages(Boolean ignoreNonFatalMessages)
   at Microsoft.SqlServer.Server.SmiEventSink_Default.DispatchMessages(Boolean ignoreNonFatalMessages)
   at Microsoft.SqlServer.Server.SmiEventSink_Default.DispatchMessages(Boolean ignoreNonFatalMessages)
   at System.Data.SqlClient.SqlDataReaderSmi.InternalNextResult(Boolean ignoreNonFatalMessages)
   at System.Data.SqlClient.SqlDataReaderSmi.NextResult()
   at System.Data.SqlClient.SqlCommand.RunExecuteReaderSmi(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result)
   at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   at System.Data.SqlClient.SqlCommand.ExecuteScalar()
   at UserDefinedFunctions.HelloWorldCLR()

I have tried the SQL BOL and Google with no luck.

Here is the sample code I am using to produce this error:

HelloWorldUDF.sql

IF OBJECT_ID (N'dbo.HelloWorldUDF') IS NOT NULL
    DROP FUNCTION dbo.HelloWorldUDF
GO

CREATE FUNCTION dbo.HelloWorldUDF() RETURNS varchar(100)
AS
BEGIN
	RETURN 'Hello World'
 
END
GO

HelloWorldCLR.cs

 using System;
using System.Data;
using System.Data.SqlClient;
using System.Data.SqlTypes;
using Microsoft.SqlServer.Server;

public partial class UserDefinedFunctions
{
    [Microsoft.SqlServer.Server.SqlFunction( DataAccess = DataAccessKind.Read )]
    public static SqlString HelloWorldCLR()
    {
        using ( SqlConnection conn = new SqlConnection( "context connection=true" ) )
        {
            conn.Open();

            SqlCommand command = new SqlCommand( "SELECT dbo.HelloWorldUDF()", conn );
            return new SqlString( command.ExecuteScalar().ToString() );
        }
    }
};

Test query: 
 select dbo.HelloWorldUDF()
select dbo.HelloWorldCLR()
 
 
Could some one please confirm that this should be possible or not?
 
Thanks!
 
Joe.

Re: What value to pass to aspnet_Membership_CreateUser for PasswordSalt parameter?

daveblack — Thu, 20 Mar 2008 04:00:00 GMT

One other alternative is to use SQL CLR (C# or VB.NET in SQL) to create a new SQL StoredProc which would be called from your Trigger. Note that this is a feature only available in SQL Server 2005+. Also, be aware that the Performance of SQL CLR is SLOWER that T-SQL. So, in general, the use of SQL CLR should be used sparingly and only in non-performance critical situations. In my opinion, SQL CLR is one of those things that MS tried to push but never really caught on with Developers and will be (or has been) superceded by LINQ. From what I've seen, the only teams that used it extensively used it as a crutch for .NET guys who couldn't write SQL. However, in your particular situation SQL CLR is the only other option AFAIK.

To use SQL CLR:

Use SQL Server Surface Area Configuration, Surface Area Configuration for Features to enable 'CLR Integration' in SQL
The new StoredProc would be written in either C#, VB.NET, or your .NET Language of choice.
Call the .NET MembersipAPI from your SQL CLR Stored Proc.
Then, call this new SQL CLR Stored Proc from your Trigger.

You can fnd more info at:

http://blogs.msdn.com/sqlclr/

http://www.google.com/search?sourceid=navclient&aq=t&ie=UTF-8&rls=GGLL,GGLL:2008-04,GGLL:en&q=sqlclr+stored+procedure

Hope this helps. If this helps to answer your question, pleae mark the response as Answer or Helpful.

Re: how to take control to free up memory immediately

roni_schuetz — Sat, 26 Jan 2008 05:00:00 GMT

i def. found what i needed and have written down the whole thing at my blog: http://netrsc.blogspot.com/2008/01/gccollect-how-it-really-works-net.html

use GC.Collect() which after some work with Perfmon showed me that this is the right thing and it does exaclty what i needed. read the blog post for more detailed information.

---

update: svante, i have seen your reply only after I submit. we have implemented a provider for caching ( even that .net does not have a provider for caching ). a project like

indeXus.Net Shared Cache needs full control of what happens behind the scene - another point which has spoken against System.Cache. We have a session provider

on our roadmap which will be implemented soon. thanks for you efforts, links and the points you share with me.

Re: how to take control to free up memory immediately

roni_schuetz — Sat, 26 Jan 2008 05:00:00 GMT

thanks for your response. Your interpretation is absolutely correct that I develop a caching system - it is a distributed caching system ( http://www.sharedcache.com ) for .net solutions.

since the requirement comes up to limit or non limit cache amount and its used here in various cases, the need to free up memory is one of this things we would like to ensure it happens asap and not just 3 - 4 min. later. It would be to simple to take the System.Web.Caching.Cache then this gives you a lot of options and capabilities we do not support but we need performance out of proc. Don't misunderstand me its amazing for almost every use-cases, but once you run into distributed caching it def. not the right way to deal with it. In general it has different aspects then the community of indeXus.Net Shared Cache needs.

We do not try to replace the System Cache we intend to give an alternative to enrich your environment out of the process.

I should also say that in general I fully agree with your point of view - do not mess with something which intends to work perfect ;-)